SQL*Loader-908: Unable to lock table TRADES due to ORACLE error 54
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.
Click Here to Expand Forum to Full Width