Rebuild Index option -- Oracle Enterprise stage

[bensonian]

Job is like this:

SEQ --> Transform --> Oracle Enterprise stage

Stage options:

Write method: Load
with 'Rebuild Index' option turned on.

I just have a record in the file, which gets inserted into the database but 'DataStage Director' strangely reports that its a fatal error but sucessfully runs to completion.

Here is the error message:

Oracle_Enterprise_27,0: Oracle call failed; sqlcode = -1,418; message: ORA-01418: specified index does not exist

Could any guru's explain me what actually is happening here and how can this be fixed???

Appreciate all your help.

[chulett]

Sounds like you have the grants you need to see the index, but not enough to drop / rebuild it. Check with your DBA, show them the ORA error.

[bensonian]

Thanks chulett.