...67891011
  • RAC and parallel server

    What is difference between RAC and parallel server?

    667983690 pointsBadges:
  • 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

    PRASAD550 pointsBadges:
  • Adding column to an exiting primary key

    We have a table which already has a primary key. We want to make this have a composite primary key with another column. Is there any other way to do this without dropping the primary key and recreating a composite PK. Thanks in advance.

    PRASAD550 pointsBadges:
  • 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 collect...

    PRASAD550 pointsBadges:
  • 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...

    Abkeyte0 pointsBadges:
  • 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...

    170519660 pointsBadges:
  • Problem with dblinks generated from Oracle Warehouse Builder

    Hi, I am using Oracle Warehouse Builder 9i to implement my data warehouse. Normally, it generates dblinks containing a TNS reference: create database link <hostname>@<connector> connect to <user> identified by <password> using '<hostname>'; But sometimes it generates...

    ActorJack0 pointsBadges:
  • 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 as EXP_FULL_DATABASE. Has anyone else...

    Oconnra0 pointsBadges:
...67891011

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following