Welcome to plsql4all.blogspot.com SQL, MYSQL, ORACLE, TERADATA, MONGODB, MARIADB, GREENPLUM, DB2, POSTGRESQL.

Sunday 24 April 2016

ORA-00069

             ORA-00069: cannot acquire lock -- table locks disabled for string.

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

              Action: Use the ALTER TABLE ... ENABLE TABLE LOCK command, and retry the command

No comments:

Post a Comment

Please provide your feedback in the comments section above. Please don't forget to follow.