| sql loader problem (merged 2 threads) [message #244008] |
Mon, 11 June 2007 04:58  |
gaikwadrachit
Messages: 33
Registered: June 2007
Location: mumbai
|
Member |
|
|
Hi
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  |
 |
Barbara Boehmer
Messages: 9097
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
