DSXchange

Hi,

I am using a oracle connector stage.

When it runs in insert mode the job runs fine.

But when i change the load to bulk mode the job aborts with the following error.

"Oracle_Connector_676,0: [IIS-CONN-ORA-001003] The OCI function OCIDirPathPrepare returned status -1. Error code: 600, Error message: ORA-00600: internal error code, arguments: [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s]. (CC_OraLoad::prepareDirectPathLoad, file CC_OraLoad.cpp, line 1,246)"


Any halp will be greatly appreciated.

REgards,
Samyam

ORA-00600 errors are a catch-all "something really bad happened but I can't tell you what" kind of error. You should probably take it to your DBA and see what they can find in the alert log. Are you able to buk load the table outside of DataStage? If nothing turns up on the Oracle side, I would suggest taking the issue to your official support provider.

My first guess would be that the userid you are using doesn't have sufficient rights in the database to drop/build indices as the bulk loader is wont to do.

That will probably be an eventual issue but something that simple really shouldn't throw a 600. [shrug]

Hmmmm... does sound awfully "harsh" as an error message for insufficient access rights.

Allrite will go back the BBA's and check what this is.

DBA's have no solution for this.

Used an Oracle Enterprise stage to avoid this error.