In our application, we need to do complete refreshes on a weekly basis of all tables. We are using SAS to create datasets that are identical to our Oracle tables.
Since our data volume is decent, we are trying to use SQL*Loader to load our tables.
SQL*Loader works great for tables that do not have any foreign keys, but for the couple of tables that do have them we are getting the following error:
"Referential Integrity Constraint/Trigger Information:
NULL, UNIQUE, and PRIMARY KEY constraints are unaffected.
SQL*Loader-965: Error -1 disabling constraint FK1_TBLDETAIL on table "ESECURITY"."TBLDETAIL" "
Since we are developers and not DBAs we don't really want to have to remove the FK and re add it at the end.
Are there any alternatives? Is there a SQL*Loader option to ignore FKs? Thoughts would be appreciated!!