Parallel loading with SQL loader Direct path

[saikrishna]

Hi

We were having multiple huge sized input files, that needs to be loaded to a single table.

We designed a job, which gets data from a file and load it to table.

SEQFILE -> TFM -> Oracle SQL Loader Stage

We enabled multiple instance to this job.

Currently we would like to run multiple instances of this job parallelly with different file parameters.

Currently it is giving the following error:


loadFactClickStream.2.Fact_clickstream: 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

Is there any way to specify PARALLEL= TRUE in the control file it is going to generate and use. We could not see any Parallel option in the Oracle SQL loader stage.

Can you please give us your thoughts on how do we do this problem.

Thanks
Sai

[gabrielac]

I believe your problem is that Oracle does not allow multiple simultaneous LOADs to the same table at the same time.
HTH,
Gaby

[chulett]

That can only work if the target table is partitioned and each instance loads a specific partition, I believe.