DSXchange

Hi All,

I am using oracle connector stage without any reject link right now..
and getting following errors for Bulk Load..

Tble: [IIS-CONN-ORA-004006] The connector generated the following TRUNCATE TABLE statement at runtime: TRUNCATE TABLE TBLE_NAME.
[IIS-CONN-ORA-004009] The connector truncated the table TBLE_NAME.

Tble: [IIS-CONN-ORA-001003] The OCI function executeDirect returned status -1. Error code: 942, Error message: ORA-00942: table or view does not exist. (CC_OraLoad::executeStatement2, file CC_OraLoad.cpp, line 2,858)


While target table is still on the database , I am getting above errors.

And what should be given in "Exceptions table name" property,

though I read the manual for it still kind of unclear.

Any inputs greatly appreciated.

Thank you all.

Hi,

try to check from your DS job whether you are able to connect to the table from the stage itself. i mean, try giving proper access privilege and schema name.

Hi,

check out for the CASE sensitivity of the table name. Check whether you have specified the right table name as on the SQL devoloper query builder or not.
because in some cases the ORA table names are case sensitive.
And may i know what kind of operation you are undergoing in the oracle stage?

If it was resolved then what was the solution? Was it setting the NLS_LANG parameter?