1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

ORA-00069 cannot acquire lock

Discussion in 'SQL PL/SQL' started by artmast, Aug 1, 2010.

  1. artmast

    artmast Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
    Hi, I am getting the Oracle Database error "ORA-00069 cannot acquire lock -- table locks disabled for string" in a stored proc. According to some sites I looked at, it says the Cause is "A command was issued that tried to lock the table indicated in the message. Examples of commands that can lock tables are: LOCK TABLE, ALTER TABLE ... ADD (...), and so on.". And the Action they suggest is "Use the ALTER TABLE ... ENABLE TABLE LOCK command, and retry the command".

    I am not doing either a lock table or alter table command in my procedure, so what else could be causing this?

    Thank you for any help. Sorry if this is an easy one, but I am new to Oracle.
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,345
    Likes Received:
    347
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    Someone has disabled table locks for the table throwing the error. You will need to issue:

    alter table <table name> enable table locks;

    to fix this.
     
  3. rajavu

    rajavu Forum Guru

    Messages:
    815
    Likes Received:
    52
    Trophy Points:
    610
    Location:
    @ Bangalore , India
    One Informative link here