Re: URGENT ---------> SQLLDR ERROR

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_at_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
Received on Tue Jan 13 2004 - 23:24:51 CET