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

[pargat singh]

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

[Mark D Powell]

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 --

[Daniel Roy]

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