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.
Rebuild Index option -- Oracle Enterprise stage
Moderators: chulett, rschirm, roy