469,072 Members | 1,849 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,072 developers. It's quick & easy.

sqlloader

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.
Jun 20 '07 #1
0 1024

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by Greg H | last post: by
3 posts views Thread by Raghu | last post: by
reply views Thread by MihirShah | last post: by
1 post views Thread by orajit | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.