DEFRAG. ORACLE TABLES WITH CONSTRAINTS - (DISABLE OR DROP?)
From: Charles Crow <us018166_at_interramp.com>
Date: 1995/12/16
Message-ID: <4av47c$cl3_at_usenet4.interramp.com>#1/1
Date: 1995/12/16
Message-ID: <4av47c$cl3_at_usenet4.interramp.com>#1/1
I am trying to defrag Oracle tables with primary and foreign keys
constraints with out dropping the constraints.
I would like to EXP the tables to disk; disable the foreign keys;
drop the tables; IMP the tables; and enable the foreign keys.
This is not working. I get an ORA-02266 foreign key pointing at primary
---etc.
Must I alway drop may constraints ?!?!
Is there away ? What is it?