Oracle OCI Load stage (Automatic)

[rajendran77]

HI Folks,
I design a job which will dump records from file(data file) to Table.
I used Oracle OCI Load stage of AUTOMATIC option.When I run the job my job got aborted with the following error message

SqlLdr_Tst..Tgt_Market_Trade: Internal Error: Unable to initialize the Direct Path Context
ORA-02373: Error parsing insert statement for table SSENG_USER1.TEST.
ORA-00904: "COL1": invalid identifier

I have datafile and Control file in the mentioned path. Let me know how to rectify this problem

Thanks in advance

Rajendran :?

[chulett]

Welcome aboard. :D

That error simply means that at least one of the columns you've included in the stage does not exist in the target table. In this case, one called 'COL1'.

[Abburi]

HI Folks,
I design a job which will dump records from file(data file) to Table.
I used Oracle OCI Load stage of AUTOMATIC option.When I run the job my job got aborted with the following error message

SqlLdr_Tst..Tgt_Market_Trade: Internal Error: Unable to initialize the Direct Path Context
ORA-02373: Error parsing insert statement for table SSENG_USER1.TEST.
ORA-00904: "COL1": invalid identifier

I have datafile and Control file in the mentioned path. Let me know how to rectify this problem

Thanks in advance

Rajendran

The column COL1 name entered is either missing or invalid, check column

[rajendran77]

Thanks. Its works fine. COL1 doesn't exist in the metadata as some user has been alter the table.

[ray.wurlod]

Then your enterprise's communication processes need better management.