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.=20 -----Original Message----- Paul Baumgartel Given some of what I've learned (from Jonathan Lewis's DBAzine article) about the performance of "exchange partition", I'm not so eager to go that route now. --- Jacques Kilchoer <Jacques.Kilchoer@xxxxxxxxx> wrote: > You could always write triggers to emulate the foreign keys, disable > the > foreign keys, do the exchange partition, re-enable the foreign keys, > and > drop the triggers. ---------------------------------------------------------------- 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 -----------------------------------------------------------------