Re: SQL*Loader-908: Unable to lock table due to ORACLE error 54

John
Fore more info have a look at note 258649.1 Differences between Conventional and Direct path options of SQL*Loader on metalink and yes sqlloader uses a "lock table <name> exclusive mode nowait".

/peter

exclusive mode nowait;

John Dunn wrote:

>We have a situation where batches of data are being loaded into a table
>using sqlldr all day long. sqlldr uses direct load for speed. At the same
>time we have a routine that deletes old records from the table. I believe
>that sqlldr needs to take an exclusive table lock...is that correct? Which
>would explain why I sometimes get Oracle 54 errors from sqlldr when the
>delete process is running? Is my analysis of this error correct? Any ideas
>on resolution? I presume conventional load does not take an exclusive table
>lock?
>Oracle version is 9.2
>
>
>
>
>--
>http://www.freelists.org/webpage/oracle-l
>
>
>

-- 

Best regards / Venlig hilsen

/*Peter Gram*/
Miracle A/S <http://www.miracleas.dk>
Kratvej 2
DK - 2760 Måløv

Cell:  (+45) 2527 7107
Phone: (+45) 4466 8855
Fax:   (+45) 4466 8856
Home:  (+45) 3874 5696
Skype:  peter_gram
Email: peter.gram_at_miracleas.dk

 30 Mar 2005  	 SQL Tuningsdag for Oracle-teknikere 
 2-4 May 2005  	 SQL Server Master Class with Kimberly Tripp 


------------------------------------------------------------------------

A human being should be able to change a diaper, plan an invasion, 
butcher a hog, conn a ship, design a building, write a sonnet, balance 
accounts,
build a wall, set a bone, comfort the dying, take orders, give orders, 
cooperate, act alone, solve equations, analyze a new problem, pitch manure,
program a computer, cook a tasty meal, fight efficiently, die gallantly. 
Specialization is for insects. - Robert A. Heinlein


--
http://www.freelists.org/webpage/oracle-l