RE: Data load ideas

Thanks--but what happens in the presence of enabled foreign keys that
reference these PKs, or enabled FKs in the tables to be exchanged
that reference other tables?  I am finding that I can't do the exchange
unless all FKs are disabled.  Will perform further tests tomorrow and
submit results.
> 
> --- Jacques Kilchoer <Jacques.Kilchoer@xxxxxxxxx> wrote:
> > No, after the exchange the indexes are not left in an unusable
> state.
> > See example below.



        
                
__________________________________
Do you Yahoo!?
Win a $20,000 Career Makeover at Yahoo! HotJobs  
http://hotjobs.sweepstakes.yahoo.com/careermakeover 
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: