By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,534 Members | 1,807 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,534 IT Pros & Developers. It's quick & easy.

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

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a
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

P: n/a
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.