DSXchange

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.

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.

Thanks chulett.