-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|