471,337 Members | 1,115 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,337 software developers and data experts.

sql loader

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 14 '07 #1
0 1953

Post your reply

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

Similar topics

1 post views Thread by Naresh Agarwal | last post: by
2 posts views Thread by Bo Brunsgaard | last post: by
1 post views Thread by Roy Chastain | last post: by
6 posts views Thread by Wilfried Mestdagh | last post: by
1 post views Thread by annappa | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.