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.
To Load data into different tables using bulk loaders
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 252
- Joined: Mon Sep 19, 2005 10:28 pm
- Location: Melbourne, Australia
- Contact:
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.
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.
Ross Leishman