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

pargat_g_at_yahoo.com (pargat singh) wrote in message news:<59f09594.0401121223.73a4f87_at_posting.google.com>...
> 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

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 -- Received on Tue Jan 13 2004 - 22:27:53 CET