Re: importing large tables

From: Michael Serbanescu <mserban_at_postoffice.worldnet.att.net>
Date: 1997/06/29
Message-ID: <33B70438.5AE0@postoffice.worldnet.att.net>#1/1

Most likely you have one or more FOREIGN KEY constraints which reference that PRIMARY KEY. Find out the definition(s) of those FK constraints and write them into a SQL script (you will need it later on). Run the following SQL statement:

ALTER TABLE <table_name> DROP PRIMARY KEY CASCADE;

This drops the PK constraint on your table, drops the unique index ORACLE creates to enforce the PK constraint and drops all the FK constraints based on that PK. After the load, re-create the PK constraint and the FK constraints (using the SQL script that you created previously).

Hope this helps.

Michael Serbanescu

---

Lisa M. Lewis wrote:
>
> I know that when importing large tables it is a good idea to drop your
> indexes first. However when I try to drop the PK index, Oracle doesn't
> allow me to do this. Does anyone know why -- is there a way around
> this?
>
> Thanks alot!
>
> Lisa
Received on Sun Jun 29 1997 - 00:00:00 CDT