DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2006

    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..

  2. #2
    Join Date
    Sep 2002
    the table is busy and cannot be locked = you have other sessions using the table

  3. #3
    Join Date
    Mar 2006
    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

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.