Using Record Type
Can the tables be exactly the same? Can you use Oracle’s snapshots to replicate only the differences over each night? In a previous shop, we had a reporting database with a table for ITD data, another for Prior Year and then the snapshot of the current production data. We used views to join the tables [...]

View Answer   |  May 26, 2004  3:34 PM
Oracle 9i

Database groups in Ireland
I don’t happen to know of one specific to Ireland but I looked at a rather old list of Oracle links and user groups that I have and you could certainly go to www.uk.oracle.com which may have links to user groups in the uk. I also have www.oracleuser.co.uk as a user group link. If anyone [...]

View Answer   |  May 25, 2004  9:40 AM
Oracle, SQL

remotely managing database securly
So much depends on how the network is configured and what will the network/sysadmins allow you to do. I think an ideal setup would be a virtual private network. Once on that network, you could use Oracle Enterprise Manager on your client machine and connect to whatever servers you have access to. One of a [...]

View Answer   |  May 24, 2004  4:59 PM
Database, DB2, Oracle, Oracle 8i

Getting duplicate records
See my reply in subject “Duplicate records”. Regards, ActorJack

View Answer   |  May 24, 2004  8:14 AM
Oracle 9i

Duplicate records
What do you mean by “the primary key is different”? Duplicates are defined with respect to some key definition. The standard way of identifying duplicates is: SELECT … FROM table t1 WHERE EXISTS (SELECT 1 FROM table t2 WHERE t2.key_col1 = t1.key_col1 …………… AND t2.key_colN = t1.key_colN AND t2.rowid != t1.rowid) ORDER BY t1.key_col1, …, [...]

View Answer   |  May 24, 2004  8:09 AM
Oracle 8i

Novell EDirectory synching with Oracle Internet Directory 10G using Novell IDM2 (previously DirXML)
We are also looking at this same sort of sync and would like to know if you find anything out.

View Answer   |  May 21, 2004  10:29 AM
General Directories, LDAP, Novell NDS, Oracle 10g, Oracle 8i, Oracle 9i

Privileges for DBA role
I have a 9.2.0.1 database. I created a user and granted ‘create session’ to it. I logged in to it and tried a select * from dba_data_files, which failed. I wnet back and granted DBA to this user, logged back on to this user, and did the same select, and it worked. I didn’t have [...]

View Answer   |  May 19, 2004  11:38 AM
Oracle 9i

upgrade from 8i to 9i or 10g
Why wait? 9.2.0.5 is stable and offers better performance over 8.1.7.x, so why wait? Why not upgrade to 9.2 quickly and then plan for 10G giving it time to mature a bit. We support applications running 7.3.2, 8.0.5.1, 8.1.7.4 and 9.2.0.5. I’m pushing everything to 9.2.0.5 just as fast as I can.

View Answer   |  May 19, 2004  10:54 AM
Oracle

Oracle Collaboration Suite
Yes we are planning to implement the entire OCS, including Voice Mail, Video Conferencing, etc.

View Answer   |  May 19, 2004  10:10 AM
Oracle

hardware/software configuration for web site hosting
First, get a domain hosting site. I use www.1and1.com. They have PHP and MySQL included with the monthly charge. If you want to use Oracle, please be prepared to pay big bucks. Not only that, I don’t know of any that would host Oracle, but I don’t know them all. If you decide to host [...]

View Answer   |  May 18, 2004  5:25 PM
Implementation, Oracle, Web site design & management

To SPFILE or Not To SPFILE
SPFILE allows the retention of parameter changes made while the database is still up. Before SPFILE any changes made via alter system were not retained after a shutdown of database. Now you can specify changes to be made to memory and or spfile. Example : alter system set sort_area_size = 10485760 scope=both ; This will [...]

View Answer   |  May 18, 2004  11:18 AM
Oracle

Oracle Internet Directory
What 3rd party LDAP are you trying to access?

View Answer   |  May 17, 2004  10:58 AM
Oracle, Oracle Application Server

Oracle Reports development & Oracle Conurrent Manager
I haven’t seen this problem, but just wondering if you’ve tried contacting Oracle support directly and/or tried placing a ticket with their Metalink portal for information on this problem. It has been my experience that they are very helpful with these kinds of issues.

View Answer   |  May 14, 2004  10:09 AM
AIX, Oracle, Oracle Application Server, SQL

Default values in Oracle packaged procedures
If you need to hide values from people who is working in the same schema then your idea with wrapper does not work, because wrapper does not obfuscate literals. Since schema is the same then anybody can dig into wrapped package body and find values there. (By the way, starting from 9i you are prohibited [...]

View Answer   |  May 13, 2004  10:20 PM
Oracle, SQL

NLS Parameters, Character Set Selection for Saudi Arabia
I do not have the specific answer to your questions but the Globalization Guide in the 9.2 documentation set seems to address these points pretty concisely. It can be found at: http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96529/toc.htm

View Answer   |  May 13, 2004  2:05 PM
Installation/Upgrade, Oracle 9i

DISTINCT or work-around
Hi Vijay. I am going to have to recite from the Gospel of Tom Kyte on this one: benchmark, benchmark, benchmark Do not just look at the query plan… tkprof your results to see the timing of these queries. Populate test tables with tens of thousands of rows (using a pl/sql script) and see how [...]

View Answer   |  May 13, 2004  1:01 PM
Oracle, Performance/Load, SQL, Tech support

Full Export on Win 2000
What syntax are you using? What error messages are you getting? We need more information. I am currently doing a full export on one of my databases. The syntax I am using is as follows: exp userid=system file=sid_full.dmp log=sid_log.dmp full=y HTH, Brian

View Answer   |  May 13, 2004  10:54 AM
Oracle 9i, Windows 2000 Server

Problem with dblinks generated from Oracle Warehouse Builder
But what is the actual problem ? I use this form for my database links to be not dependent on tnsnames.ora stuff (we have several UNIX hosts with several Oracle instances and dummy DBAs who never keeps Oracle networking files in sync)

View Answer   |  May 13, 2004  6:06 AM
Oracle, Oracle 9i, Tech support

Oracle 9i Designer
Hi. Any of those products will allow you to document at an extremely low level of granularity. Haven’t used Designer since 6i (the previous version), but it is strongest for “traditional” data modelers (using information engineering approach) deploying to an Oracle DBMS. It’s absolutely brilliant. I especially liked the stored procedure generation aspects and CRUD [...]

View Answer   |  May 12, 2004  4:17 PM
Availability, Backup & recovery, Migration, Modeling, Normalization, Performance/Tuning, Security, Storage management, Very Large Databases

Oracle database not starting on server reboot
I use Oracle under UNIX, but not under Windows. So, my response may not be of much help. Under UNIX, the file /var/opt/oracle/oratab has a line of the form $ORACLE_SID:$ORACLE_HOME:<N|Y>, where the first and the second fields are the system identifier and home directory of the database respectively. The third field indicates to the ‘dbstart’ [...]

View Answer   |  May 12, 2004  4:12 PM
Oracle 8i