Duplicate records
What is the best way to detect duplicate records within a large database where the primary key is different?
Answer Question
| May 24, 2004 6:45 AM
Oracle 8i
What is the best way to detect duplicate records within a large database where the primary key is different?
Answer Question
| May 24, 2004 6:45 AM
Oracle 8i
Getting duplicate records
I have looked onto the web for finding duplicate records. However most the queries given finds one of the duplicate records. Our requirement is to find both (or multiple) duplicate records from a table. We are using Oracle 9i. Regards
Answer Question
| May 27, 2004 7:48 AM
Oracle 9i
I have looked onto the web for finding duplicate records. However most the queries given finds one of the duplicate records. Our requirement is to find both (or multiple) duplicate records from a table. We are using Oracle 9i. Regards
Answer Question
| May 27, 2004 7:48 AM
Oracle 9i
Using Record Type
We have a table with 70 columns and everyday we move data from thsi table to its history table which is basically same in structure. The daily table has about 4 million records that is tranferred to the history table. To move data from this daily table to the hostory table we are using bulk [...]
Answer Question
| May 26, 2004 7:44 AM
Oracle 9i
We have a table with 70 columns and everyday we move data from thsi table to its history table which is basically same in structure. The daily table has about 4 million records that is tranferred to the history table. To move data from this daily table to the hostory table we are using bulk [...]
Answer Question
| May 26, 2004 7:44 AM
Oracle 9i
Novell EDirectory synching with Oracle Internet Directory 10G using Novell IDM2 (previously DirXML)
Any of you guys have any experience on this? Any tips or probably a step-by-step guideline to follow going about this?
Answer Question
| June 3, 2004 5:40 AM
General Directories, LDAP, Novell NDS, Oracle 10g, Oracle 8i, Oracle 9i
Any of you guys have any experience on this? Any tips or probably a step-by-step guideline to follow going about this?
Answer Question
| June 3, 2004 5:40 AM
General Directories, LDAP, Novell NDS, Oracle 10g, Oracle 8i, Oracle 9i
Privileges for DBA role
In an Oracle 9.2.0.4 database I have a user with DBA as the default role. But I had to grant explicitly via “grant SELECT on …” to this user to allow it to select from DBA_ROLE_PRIVS and DBA_USERS. Since the DBA role grants all system privileges WITH ADMIN OPTION, why is it necessary to grant [...]
Answer Question
| May 20, 2004 10:49 AM
Oracle 9i
In an Oracle 9.2.0.4 database I have a user with DBA as the default role. But I had to grant explicitly via “grant SELECT on …” to this user to allow it to select from DBA_ROLE_PRIVS and DBA_USERS. Since the DBA role grants all system privileges WITH ADMIN OPTION, why is it necessary to grant [...]
Answer Question
| May 20, 2004 10:49 AM
Oracle 9i
upgrade from 8i to 9i or 10g
This question might be a bit early for some, but at the end of the year 8i on windows goes off support. We will be looking at upgrading soon after. I would also expect that 10.2 might be on the horizon at that point. One would hope that would be a stable release. I would [...]
Answer Question
| May 19, 2004 10:34 AM
Oracle
This question might be a bit early for some, but at the end of the year 8i on windows goes off support. We will be looking at upgrading soon after. I would also expect that 10.2 might be on the horizon at that point. One would hope that would be a stable release. I would [...]
Answer Question
| May 19, 2004 10:34 AM
Oracle
hardware/software configuration for web site hosting
Thanks to all for replying to my previous question. This question is of general nature. I’m planning on creating(hosting) a web site, at which the main contents will be questionnaires, polling and compiling the ratings. I know I will need the database behind the HTML front-end. I will design and develop the database and the [...]
Answer Question
| May 18, 2004 4:16 PM
Implementation, Oracle, Web site design & management
Thanks to all for replying to my previous question. This question is of general nature. I’m planning on creating(hosting) a web site, at which the main contents will be questionnaires, polling and compiling the ratings. I know I will need the database behind the HTML front-end. I will design and develop the database and the [...]
Answer Question
| May 18, 2004 4:16 PM
Implementation, Oracle, Web site design & management
To SPFILE or Not To SPFILE
Hi, What are your experiences using the SPFILE? Why would I want to use the SPFILE versus the old PFILE? Thanks! - D.
Answer Question
| May 19, 2004 10:49 AM
Oracle
Hi, What are your experiences using the SPFILE? Why would I want to use the SPFILE versus the old PFILE? Thanks! - D.
Answer Question
| May 19, 2004 10:49 AM
Oracle
Oracle Internet Directory
Has anybody successfully synchronized OID with a third-party LDAP?
Answer Question
| May 19, 2004 1:25 PM
Oracle, Oracle Application Server
Has anybody successfully synchronized OID with a third-party LDAP?
Answer Question
| May 19, 2004 1:25 PM
Oracle, Oracle Application Server
Default values in Oracle packaged procedures
What is the best way to conceal default packaged procedure parameter values? I thought of this way: Make default values NULL in the specification Make default values whatever you want them to be in the package body. Wrap (encrypt hex) package body. I need this in order to obfuscate the use of this package to [...]
Answer Question
| May 22, 2004 12:33 PM
Oracle, SQL
What is the best way to conceal default packaged procedure parameter values? I thought of this way: Make default values NULL in the specification Make default values whatever you want them to be in the package body. Wrap (encrypt hex) package body. I need this in order to obfuscate the use of this package to [...]
Answer Question
| May 22, 2004 12:33 PM
Oracle, SQL
DISTINCT or work-around
Greetings from Vijay, Consider table B as below with columns b1 and b2. Table B B1 B2 ========== 1 abc 2 xyx 3 abc 4 efg 1 xyx 3 abc 4 car 5 edf Query 1 ========= select distinct b2 from B Output : ====== B2 ============ abc car edf efg xyx Explain Plan: Query [...]
Answer Question
| May 22, 2004 12:04 PM
Oracle, Performance/Load, SQL, Tech support
Greetings from Vijay, Consider table B as below with columns b1 and b2. Table B B1 B2 ========== 1 abc 2 xyx 3 abc 4 efg 1 xyx 3 abc 4 car 5 edf Query 1 ========= select distinct b2 from B Output : ====== B2 ============ abc car edf efg xyx Explain Plan: Query [...]
Answer Question
| May 22, 2004 12:04 PM
Oracle, Performance/Load, SQL, Tech support
Full Export on Win 2000
I have spent most of my DBA life on HP/UX. I just recently installed an App on Win 2000 and was able to easily set up schema exports, but I can’t get the full database export to work. I am running it as SYSTEM and made sure that SYSTEM has the DBA role as well [...]
Answer Question
| May 13, 2004 5:08 PM
Oracle 9i, Windows 2000 Server
I have spent most of my DBA life on HP/UX. I just recently installed an App on Win 2000 and was able to easily set up schema exports, but I can’t get the full database export to work. I am running it as SYSTEM and made sure that SYSTEM has the DBA role as well [...]
Answer Question
| May 13, 2004 5:08 PM
Oracle 9i, Windows 2000 Server
Database groups in Ireland
Do you know of any associations in Ireland that specialize in Database work, such as an Oracle Users Group?
Answer Question
| June 3, 2004 4:24 PM
Oracle, SQL
Do you know of any associations in Ireland that specialize in Database work, such as an Oracle Users Group?
Answer Question
| June 3, 2004 4:24 PM
Oracle, SQL
Oracle database not starting on server reboot
Would anyone know why an Oracle 8i database running on Windows 2000 will not automatically start on a server reboot?
Answer Question
| May 12, 2004 3:30 PM
Oracle 8i
Would anyone know why an Oracle 8i database running on Windows 2000 will not automatically start on a server reboot?
Answer Question
| May 12, 2004 3:30 PM
Oracle 8i
Oracle 9i Designer
Do you have any opinions on the use of Designer versus a tool like Erwin or PowerDesigner in handling the following concerns: Database generation Reverse engineering Accurately representing every detail of a database Speed Use for different DB platforms Thanks for any comments.
Answer Question
| May 12, 2004 3:29 PM
Availability, Backup & recovery, Migration, Modeling, Normalization, Performance/Tuning, Security, Storage management, Very Large Databases
Do you have any opinions on the use of Designer versus a tool like Erwin or PowerDesigner in handling the following concerns: Database generation Reverse engineering Accurately representing every detail of a database Speed Use for different DB platforms Thanks for any comments.
Answer Question
| May 12, 2004 3:29 PM
Availability, Backup & recovery, Migration, Modeling, Normalization, Performance/Tuning, Security, Storage management, Very Large Databases
nt/2000 oracle experience to install on linux
Do you happen to know of any good resources to help a windows Oracle dba very quickly appreciate the linux environment for an install there. It would be great to have a resource that can explain the similar (or not so similar) constructs in a windows environment to that of a linux one. Thanks, Laura
Answer Question
| May 12, 2004 2:24 PM
Linux, Oracle
Do you happen to know of any good resources to help a windows Oracle dba very quickly appreciate the linux environment for an install there. It would be great to have a resource that can explain the similar (or not so similar) constructs in a windows environment to that of a linux one. Thanks, Laura
Answer Question
| May 12, 2004 2:24 PM
Linux, Oracle
Encryption in the Database
Has anyone encrypted data in their Oracle/DB2/SQLServer databases? Can you share you experiences?
Answer Question
| May 13, 2004 2:18 PM
Oracle, OS/390, SQL Server, UDB for mainframe, z/OS
Has anyone encrypted data in their Oracle/DB2/SQLServer databases? Can you share you experiences?
Answer Question
| May 13, 2004 2:18 PM
Oracle, OS/390, SQL Server, UDB for mainframe, z/OS
Oracle Reports development & Oracle Conurrent Manager
In developing using Oracle Reports, the report runs fine on the workstation through the developer tool, however when we port the .rfd to Unix and run through the Oracle Apps concurrent manager there are errors in formatting. The error messages generated are not always sufficient to determine which frame or field the error is from. [...]
Answer Question
| May 14, 2004 1:58 PM
AIX, Oracle, Oracle Application Server, SQL
In developing using Oracle Reports, the report runs fine on the workstation through the developer tool, however when we port the .rfd to Unix and run through the Oracle Apps concurrent manager there are errors in formatting. The error messages generated are not always sufficient to determine which frame or field the error is from. [...]
Answer Question
| May 14, 2004 1:58 PM
AIX, Oracle, Oracle Application Server, SQL
NLS Parameters, Character Set Selection for Saudi Arabia
HI, I need to create a data warehouse in Saudi Arabia, on Oracle 9.2.0. The database will store almost everything in English, but will need to store Arabic names in Arabic, and will need to handle both gregorian and hijri date formats and display them correctly. This same database may later need to support Chinese [...]
Answer Question
| May 21, 2004 12:58 PM
Installation/Upgrade, Oracle 9i
HI, I need to create a data warehouse in Saudi Arabia, on Oracle 9.2.0. The database will store almost everything in English, but will need to store Arabic names in Arabic, and will need to handle both gregorian and hijri date formats and display them correctly. This same database may later need to support Chinese [...]
Answer Question
| May 21, 2004 12:58 PM
Installation/Upgrade, Oracle 9i
Oracle 10g ASM
Can you create ASM instance without creating a database? If yes, how?
Answer Question
| May 18, 2004 12:52 PM
Oracle, Oracle 10g
Can you create ASM instance without creating a database? If yes, how?
Answer Question
| May 18, 2004 12:52 PM
Oracle, Oracle 10g
