Re: DEFRAG. ORACLE TABLES WITH CONSTRAINTS - (DISABLE OR DROP?)

In article <30D3385A.2369_at_ccm.tdsnet.com>, vnair_at_ccm.tdsnet.com says... Charles Crow wrote:
*>>
*>> 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?
*>
*>
*>*Hi,
*>
*>You need to drop the constraints pointing to the table being dropped.
*>This include the foreign key constraints pointing to this table.
*>At present Iam working to generate the required scripts from the
*>dictionary itself. Hopefully, that should be ready in couple of days. If
*>you need more details, please contact me.
*>
*>Vijay Nair
*>vnair_at_ccm.tdsnet.com

I usually do the import process in these steps:

• import structures, no data, no indexes
• generate scripts to disable triggers, constraints and primary keys.
• import data only, no indexes.
• import indexes only no data, or create indexes my using the show=y param to get the ddl.
• emable the triggers, constraints and primary keys.