471,090 Members | 1,335 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

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

URGENT ---------> SQLLDR ERROR

Hi Everyone

I am using SQLLDR to load the data and i am getting following error

SQL*Loader-908: Unable to lock table TABLE_NAME due to ORACLE
error 54.

Loader Cmd is

SQLLDR.EXE userid=XXXXX/YYYY@ZZZZ control=S:\.......\iss3_memdoc.ctl
direct=true log=S:\.....\iss3_SQLLDR_Memdoc.log
bad=S:\....\iss3_memdoc.bad data=S:\....\iss3_memdoc.dat
discard='S:\....\iss3_memdoc.discard' errors=1000 rows=20000

Can anyone please tell me what is wrong and what i can do to fix it.

Thanks in advance.

Pargat Gill
Jul 19 '05 #1
2 6282
pa******@yahoo.com (pargat singh) wrote in message news:<59*************************@posting.google.c om>...
Hi Everyone

I am using SQLLDR to load the data and i am getting following error

SQL*Loader-908: Unable to lock table TABLE_NAME due to ORACLE
error 54.

Loader Cmd is

SQLLDR.EXE userid=XXXXX/YYYY@ZZZZ control=S:\.......\iss3_memdoc.ctl
direct=true log=S:\.....\iss3_SQLLDR_Memdoc.log
bad=S:\....\iss3_memdoc.bad data=S:\....\iss3_memdoc.dat
discard='S:\....\iss3_memdoc.discard' errors=1000 rows=20000

Can anyone please tell me what is wrong and what i can do to fix it.

Thanks in advance.

Pargat Gill


Error 54 is ORA-00054 "resource busy and acquire with NOWAIT
specified", which means that the table is in use. Find all sessions
using the table and terminate them or use a conventional load.

HTH -- Mark D Powell --
Jul 19 '05 #2
Here's Oracle's description on this error message:

Action: Check the message below this one in the log file for more
information. Find the object number of the table in the catalog view
USER_OBJECTS. Use the SQL*DBA MONITOR LOCK command to list all
processes with outstanding locks. Identify the process that has the
lock on the table. Then use the MONITOR PROCESS command to find out
who is connected as the Oracle process holding the lock and get them
to relinquish it, or wait and retry.

Daniel
Hi Everyone

I am using SQLLDR to load the data and i am getting following error

SQL*Loader-908: Unable to lock table TABLE_NAME due to ORACLE
error 54.

Loader Cmd is

SQLLDR.EXE userid=XXXXX/YYYY@ZZZZ control=S:\.......\iss3_memdoc.ctl
direct=true log=S:\.....\iss3_SQLLDR_Memdoc.log
bad=S:\....\iss3_memdoc.bad data=S:\....\iss3_memdoc.dat
discard='S:\....\iss3_memdoc.discard' errors=1000 rows=20000

Can anyone please tell me what is wrong and what i can do to fix it.

Thanks in advance.

Pargat Gill

Jul 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by hb | last post: by
4 posts views Thread by Don Wash | last post: by
2 posts views Thread by pargat singh | 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.