Job Aborted due to Oracle Error
Posted: Thu Oct 07, 2004 4:21 am
Hi Everyone,
I was running a job in multiple instance that updates an Oracle table (R_BATCH). The job accepts parameters for invocation ID and I made sure that each instance has a unique invocation ID. The job aborted with the DS Director log refering me the Oracle log file. When I opened it, the error says:
"SQL*Loader-937: parallel load requested and R_BATCH has enabled triggers or constraints."
Can anybody tell me how to address this?
Thanks in advance.
I was running a job in multiple instance that updates an Oracle table (R_BATCH). The job accepts parameters for invocation ID and I made sure that each instance has a unique invocation ID. The job aborted with the DS Director log refering me the Oracle log file. When I opened it, the error says:
"SQL*Loader-937: parallel load requested and R_BATCH has enabled triggers or constraints."
Can anybody tell me how to address this?
Thanks in advance.