How to fix the error ORA-00069: cannot acquire lock — table locks disabled for string?

In this post, you’ll learn more about the Oracle ErrorORA-00069: cannot acquire lock — table locks disabled for string with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

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

Reason for the Error ORA-00069: cannot acquire lock — table locks disabled for string

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.

How to fix the Error ORA-00069: cannot acquire lock — table locks disabled for string ?

You can fix this error in Oracle by following the below steps

Use the ALTER TABLE … ENABLE TABLE LOCK command, and retry the command.