Jacques, thanks, you are quite right. Somehow I missed that constraint state. However, after the exchange, the indexes are left in unusable state, and must be rebuilt, no? At least that's what happened when I tried it. That, in turn, is not compatible with keeping the site fully available during the data load operation. --- Jacques Kilchoer <Jacques.Kilchoer@xxxxxxxxx> wrote: > I haven't read the article (going to look for it now), but if you > have > primary / unique constraints in an enable novalidate state and use > "exchange partition without validation" the exchange partition seems > to > be lightning fast. __________________________________ 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 //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------