Re: Urgent ---- SQLLDR Error

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Mon, 12 Jan 2004 21:27:16 +0100
Message-ID: <8l0600d1kf20u14igehj2m4n4kmfsp26d4@4ax.com>

On 12 Jan 2004 12:22:27 -0800, pargat_g_at_yahoo.com (pargat singh) wrote:

>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

The table is locked by a different process. To fix it you need to find the process and kill it.

Better still you load your data in a separate staging table, after which you clean it up and use insert select statements to get it over to the production table.

BTW: There is no such thing as an 'URGENT' request in a volunteer newsgroup. If it is really urgent get paid support.

--
Sybrand Bakker, Senior Oracle DBA

Received on Mon Jan 12 2004 - 14:27:16 CST