Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Data load ideas
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.
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Wed Apr 28 2004 - 17:36:31 CDT
![]() |
![]() |