Oracle Loads with Trigger and Constraints enabled
Moderators: chulett, rschirm, roy
Oracle Loads with Trigger and Constraints enabled
Is there any way to load records into non empty existing tables with constraints, triggers enabled? In this case I'm loading(Append) records into table. With no option to disabling constraints and rebuilding index.
Any help greatly appreciated.
Thank you.
Any help greatly appreciated.
Thank you.
Oh, sorry... you specifically meant a direct path sqlldr type load. There's some useful information here* which may help. Oracle will disable constraints (etc) during a direct path load but PX may not like it. Was the message from DataStage or Oracle? Can you post the complete, unedited message and any others it might have logged that seem relevant?
Link didn't work with the splat in it, you'll need to cut/paste into your browser to get it to work:
http://www.orafaq.com/wiki/SQL*Loader
Link didn't work with the splat in it, you'll need to cut/paste into your browser to get it to work:
http://www.orafaq.com/wiki/SQL*Loader
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
If you don't want to (or cannot) do that, you'll need to switch to a conventional load (DIRECT=FALSE) for that table. That basically does 'normal' inserts.SQL*Loader-937: parallel load requested and name has enabled triggers or constraints
Cause: A request was made for a parallel direct load, but the object to be loaded has an enabled constraint (check, referential) and/or enabled triggers.
Action: Disable the offending enabled constraints and/or triggers and retry the parallel direct load.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers