Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Data load ideas
I did some testing since i'm going to implement something like that for
the warehouse project i'm working on.
what i'm finding is when i create the table to hold the data(that will be exchanged from), if i add the FK to that table before the exchange is done(and everyone is enable validate right now), i have no problem doing the exchange.
so i must be missing something here in the thread, what is it?
joe
****original message below ****
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.
-- 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 Fri Apr 30 2004 - 07:35:12 CDT
![]() |
![]() |