SQL*Loader-908: Unable to lock table TRADES due to ORACLE error 54
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

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

  1. #1
    Join Date
    Mar 2006
    Posts
    9

    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
    Location
    England
    Posts
    7,333
    the table is busy and cannot be locked = you have other sessions using the table

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