Abort because of Index in diffrent Environment

kamalshil · Post by **kamalshil** » Mon Sep 13, 2010 3:29 am

Hi,
I am using oracle enterprise stage for loading the table.
Write method is 'Load'.
write mode is 'Truncate'.

And target table has no index.

In our dev environment and testing its running fine.

But when we put this code in different environment its giving below abort message.

Code: Select all

Indexes on table 'TMP_T' preclude direct parallel loading unless an index option is included. Add an index option or drop indexes and rerun step.

Is this a environment problem.
do i need to change some environment variables?

chulett · Post by **chulett** » Mon Sep 13, 2010 6:28 am

So you tested against a target table with no indexes but it has some in production? Hmmm...

As noted in the error you need to "Add an index option or drop indexes and rerun step", the "index option" is a property of the stage.

kamalshil · Post by **kamalshil** » Mon Sep 13, 2010 7:11 am

Yes as my target table has no index.
so there is no need to use index option to add index or drop index.

chulett · Post by **chulett** » Mon Sep 13, 2010 7:24 am

Your error message says otherwise. Double-check.

priyadarshikunal · Post by **priyadarshikunal** » Mon Sep 13, 2010 10:03 am

Check the value of APT_ORACLE_LOAD_OPTIONS environment variable in both environment.