Oracle EE Stage: SQL Loader Error

cdw · Post by **cdw** » Sun Jul 19, 2009 11:28 pm

Hi,

I am using the Oracle EE stage to load data to a table.

The default options of DIRECT and PARALLEL = TRUE are set. I have set Disable Constraints property to 'True' and have also included Index Option of Rebuild.

The job aborts with the message:

[quote]SQL*Loader 937: Parallel load requested and table has enabled constraints or triggers.[/quote]

When option of Disable constraints is set to 'True' shouldnt the constraints be disable prior to load and re-enabled later?

Does this need to be done explicitly before the OEE stage

Regards,
Bakul

chulett · Post by **chulett** » Mon Jul 20, 2009 6:26 am

Any other error messages logged? Does the connected user have the grants needed to disable constraints and rebuild indexes?

cdw · Post by **cdw** » Mon Jul 27, 2009 6:21 am

:? My mistake.. The table had some triggers created by Erwin.

Dropped them and there are no issues now.

Regards,
Bakul