Home » RDBMS Server » Server Utilities » sql loader problem (merged 2 threads)
sql loader problem (merged 2 threads) [message #244008] Mon, 11 June 2007 04:58 Go to next message
Messages: 33
Registered: June 2007
Location: mumbai
We are uploading a picture image(jpg) as a BLOB in a table using
SQL Loader. We are parallely uploading the images at the same time from 2 different sessions on the server.
The command for uploading is as follows
SQLLDR username/password@DATABASE control=controlfile.ctl log=logfile.log DIRECT=TRUE
But on uploading the files simultaneously, we are getting the following error on one of the sessions.

>ORA-00604: error occurred at recursive SQL level 1
>ORA-00054: resource busy and acquire with NOWAIT specified

To resolve this issue we have added the option of PARALLEL = TRUE to the command. But we are getting the error

SQL*Loader-971: parallel load option not allowed when loading lob columns

Thus the combination of DIRECT=TRUE & PARALLEL=TRUE along with LOB datatypes is not giving us the desired result with SQL Loader .
Can you please help us resolve this issue.
Thanks in advance.
Re: sqlloader problem [message #246446 is a reply to message #244008] Thu, 21 June 2007 00:36 Go to previous message
Barbara Boehmer
Messages: 8737
Registered: November 2002
Location: California, USA
Senior Member
Like the error message says, and you seem to have deduced, you can't use that combination, so the solution is not to use that combination. Don't use parallel load or direct=true, just load it normally using the conventional path.
Previous Topic: error while importing the dump file
Next Topic: Export
Goto Forum:

Current Time: Sun Aug 20 19:40:34 CDT 2017

Total time taken to generate the page: 0.06277 seconds