Getting error APT_ORACLE_LOAD_OPTIONS

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
skaruturi
Participant
Posts: 10
Joined: Wed Sep 13, 2006 2:17 am

Getting error APT_ORACLE_LOAD_OPTIONS

Post by skaruturi »

when i an trying to populate data to a sdatabse table ,the job is aborting with error message as

When checking operator: APT_ORACLE_LOAD_OPTIONS has been set by user. Therefore, Orchestrate assumes that the DIRECT and/or PARALLEL options have been set to FALSE, and that it is okay to load table 'TABLENAME', even though it is indexed, and an index option (rebuild or maintenance) has not been included. APT_ORACLE_LOAD_OPTIONS has been set by the user to 'OPTIONS(DIRECT=FALSE,PARALLEL=TRUE)'.

can any body help
nick.bond
Charter Member
Charter Member
Posts: 230
Joined: Thu Jan 15, 2004 12:00 pm
Location: London

Post by nick.bond »

You need to check the valid cvobminations of options with Oracle. I don't have the documentation at the moment but I think if this is causing and error you need to "disable constraints" option turned on in the Oracle stage when you have Parallel = True in the load options.
Regards,

Nick.
RamonaReed
Participant
Posts: 26
Joined: Fri Feb 27, 2004 7:23 am
Location: WI, USA

Post by RamonaReed »

It sounds like you are using Write Method = Load, If so, add the option:
Disable Constraints = False
Index Mode = Rebuild
Post Reply