Reorg of 7.3.3.5.1 tables with lots ot Referential Integrity

From: Ross Coventry <ross.coventry_at_c031.aone.net.au>
Date: Thu, 15 Oct 1998 20:02:38 GMT
Message-ID: <703oi9$r42$1@news.mel.aone.net.au>

Hi Folks,

I have a large database on HPUX 10.20, Oracle server 7.3.3.5.1 which has need of some table reorganisation. Unfortunately this is our only database with plenty of RI incorporated within it.

The database is too big to run a complete export/import of the schema involved.

I have learned how to determine the contraints on an individual table and how to see it parent table via foreign keys. I assume one can see its child tables via the Referenced table column as well.

I am with the belief now that disabling the RI contraints of a table (ie: leaving the Check and Primary key constraints alone) and then exporting and importing the table, enabling constraints is enough to reorg the table. Of course this is done in standalone mode.

Does this work? Is there more I should do. I assume I would run all the reports I can to pre and post to check that constraints came back online okay, etc etc.

Should the constraints of the parent table and child table also be disabled at this time?

Many thanks in advance.....Ian Evans. Received on Thu Oct 15 1998 - 15:02:38 CDT