DSXchange

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

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

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

Dropped them and there are no issues now.

Regards,
Bakul