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

Hi all,

Now for the sqlldr i am using the following,

oracle 8i and sqlldr of same version. Catldr is executed.

when direct = false the data are uploaded fine ..

But when direct = true then getting the error

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

How to clear the problem?? Thanks in advance..

the table is busy and cannot be locked = you have other sessions using the table

yes sir, you are absolutely correct. I had the same problem and what i did is, killed the other sessions, using the table.

So it worked like charm and my analysis work completed. Thanks for all your help and support.