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:\.....\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

[Mark D Powell]

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

pargat_g@yahoo. com (pargat singh) wrote in message news:<59f09594. 0401121223.73a4 f87@posting.goo gle.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@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

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]

Re: URGENT ---------&gt; 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@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