Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.oracle -> URGENT ---------> SQLLDR ERROR

URGENT ---------> SQLLDR ERROR

From: pargat singh <pargat_g_at_yahoo.com>
Date: 12 Jan 2004 12:23:29 -0800
Message-ID: <59f09594.0401121223.73a4f87@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 Received on Mon Jan 12 2004 - 14:23:29 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US