To Load data into different tables using bulk loaders

Christina · Post by **Christina** » Thu Jan 11, 2007 9:15 am

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.

chulett · Post by **chulett** » Thu Jan 11, 2007 9:30 am

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.

rleishman · Post by **rleishman** » Thu Jan 11, 2007 8:06 pm

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.

Christina · Post by **Christina** » Fri Jan 12, 2007 4:01 am

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

chulett · Post by **chulett** » Fri Jan 12, 2007 7:30 am

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'.