Oracle Loads with Trigger and Constraints enabled

[theone]

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.

[chulett]

Sure... just make sure you don't violate any of the constraints. What have you tried? What issues are you having?

[theone]

Error says : parallel load requested and XYZ has enabled triggers or constraints

[chulett]

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

[theone]

Complete Error:

SQL*Loader-937: Parallel load requested and XYZ has enabled triggers or constraints.

Thank you.

[chulett]

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.

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.

[theone]

Thank you for the help, to switch to a conventional load (DIRECT=FALSE) is that a datastage option or an oracle setting?

[chulett]

It's an Oracle setting you would have DataStage provide. There's a place in the stage for 'load options' I do believe, can't check right now however.

[theone]

I figured it out, thank you!!!