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

Home -> Community -> Usenet -> c.d.o.server -> Urgent ---- SQLLDR Error

Urgent ---- SQLLDR Error

From: pargat singh <pargat_g_at_yahoo.com>
Date: 12 Jan 2004 12:22:27 -0800
Message-ID: <59f09594.0401121222.32a65a2e@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:22:27 CST

Original text of this message

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