Re: importing large tables

From: Stuart Turton <sturton_at_maderich.demon.co.uk>
Date: 1997/06/29
Message-ID: <33B59BB2.CB0F684B@maderich.demon.co.uk>#1/1

Try 'ALTER TABLE DISABLE CONSTRAINT PK_...

Oracle will not allow you to drop an Index which is used by a constraint.

If you disable the associated constraint the index is automatically dropped.
Then you can use ALTER TABLE ENABLE CONSTRAINT ...

You can create your index with your choice of tablespace, initial extent, next extents, etc..
The ENABLE CONSTRAINT .. command will look for a matching unique index and 'take it over' for use by the constraint. Even better the column information for the index is stored in USER_CONSTRAINTS or ALL_CONSTRAINTS, so you can automatically generate index creation statements even though the index has been dropped.

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