Index rebuild failed

[kamalshil]

Hi all,

My table is partitioned.
And when i am trying to load the table with the load option.
And Index Mode = rebuild.

I am getting below fatal error:

Code: Select all

Ora_load: The -index rebuild option may not be used on a partitioned index;
table 'TABLENAME' contains one or more partitioned indexes.

What has to be done to resolve this problem any suggestions?

It was running fine when the table was not partitioned.

[ArndW]

This is not a DataStage limitation, but a database one and thus cannot be solved by DataStage.

[kamalshil]

This is not a DataStage limitation, but a database one and thus cannot be solved by DataStage. ...

Thanks,
But parameter i need to take care at the database end to make this possible to work the Load method.

Or i have to use the upsert option.

[ArndW]

Wasn't there a maintenance mode available as well, or how about just deleting that parameter in the specification? Oracle is the limiting factor here, not DataStage - the "rebuild" option is part of the oracle loader.

[chulett]

Talk to your DBA.