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:\.....\is s3_SQLLDR_Memdo c.log
bad=S:\....\iss 3_memdoc.bad data=S:\....\is s3_memdoc.dat
discard='S:\... .\iss3_memdoc.d iscard' 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
>
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:\.....\is s3_SQLLDR_Memdo c.log
bad=S:\....\iss 3_memdoc.bad data=S:\....\is s3_memdoc.dat
discard='S:\... .\iss3_memdoc.d iscard' 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
Leave a comment: