sql loader issue
Posted: Mon Mar 31, 2008 12:53 pm
Okay, I have two issues, and I think we've resolved one, but I wished to share to see if anyone else came across this.
First, Oracle client is 10g, Oracle Database is 9.2.0.5. This is a problem according to Oracle: "the client version must be the same or earlier than the server version, and both must be 9i or later for direct path load. Therefore,direct path load cannot be used to load data from 10g client into 9i database. In addition, a direct path load from 9.2 client into 9.0.1 database is not supported."
My error messages: Oracle_Enterprise_168,1: SQL*Loader-925: Error while uldlpim: OCIStmtExecute
Oracle_Enterprise_168,1: ORA-00904: "MESSAGE_NUM": invalid identifier
Appears there is an additional field.
That explains some, but.....
Next issue, my data actually loads into the table. hmmmm. Somehow Oracle is sending a bad return code back to DataStage or something.
Long story even longer.....Good data, bad return code, job aborts.
Suggestions? My dba said that the BladeLogic people had the same problem with return codes. I don't know who they are or what they do, but apparently, they have issues also.
Thanks,
Jason
First, Oracle client is 10g, Oracle Database is 9.2.0.5. This is a problem according to Oracle: "the client version must be the same or earlier than the server version, and both must be 9i or later for direct path load. Therefore,direct path load cannot be used to load data from 10g client into 9i database. In addition, a direct path load from 9.2 client into 9.0.1 database is not supported."
My error messages: Oracle_Enterprise_168,1: SQL*Loader-925: Error while uldlpim: OCIStmtExecute
Oracle_Enterprise_168,1: ORA-00904: "MESSAGE_NUM": invalid identifier
Appears there is an additional field.
That explains some, but.....
Next issue, my data actually loads into the table. hmmmm. Somehow Oracle is sending a bad return code back to DataStage or something.
Long story even longer.....Good data, bad return code, job aborts.
![Sad :-(](./images/smilies/icon_sad.gif)
Suggestions? My dba said that the BladeLogic people had the same problem with return codes. I don't know who they are or what they do, but apparently, they have issues also.
Thanks,
Jason