I must be missing something here but here goes:
In my Dev Project I'm loading a table which is indexed using the load method, I have the Env var set to 'OPTIONS(DIRECT=FALSE,PARALLEL=TRUE).
My dev project run works with this log entry:
after export/import to my TEST project which seems to have the same env vars definedORA_LAK_LAKOACH_INS: 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 'LAK.LAK_LAKOACH', 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)'.
job aborts and I get this error:
Any Ideas would be apreciated.ORA_LAK_LAKOACH_INS: Indexes on table 'LAK.LAK_LAKOACH' preclude direct parallel loading unless an index option is included. Add an index option or drop indexes and rerun step.
Thanks in advance for your time ,