DSXchange

Hi,
I am loading a data from one sequential file to 12 different tables. I have used 12 bulk loaders specifying the target table name in each bulk loader.While running the job i am getting the following error.

Internal Error: Unable to initialize the Direct Path Context
ORA-00604: error occurred at recursive SQL level 1
ORA-00054: resource busy and acquire with NOWAIT specified

can we use many bulk loaders specifying the table name?
Please help me on this.

Welcome. :D

The same table name? Nope. Different? Yes. Your message indicates that at least one table was 'busy' - in use by someone - and so could not be loaded.

If you are locking yourself out (multiple loads to the same table) then read on:

Oracle won't let you perform multiple direct-path / parallel loads into the same table UNLESS each load is into a different partition, and the partition name is specified in the load spec.

I suspect this may also work with OCI Load in DataStage, but I haven't tried it. I notice that there is a Partition name attribute in the OCI Load Stage it is probably for that purpose.

i am loading into different tables. its working now. thank you.

What was the resolution? Best practice is to note the actual resolution to your issue, in case anyone comes searching with the same problem. That and please mark your topic as 'Resolved'.