Need of Enabling or Disabling Table Locks in Oracle
How to Enable table locks in Oracle Database? How to disable table locks in Oracle Database? Oracle Database Tips and Tricks to Enable OR Disable table locks.
Table Locks are an important part of Oracle Working Mechanism as they provide security from unwanted deletion or modification of table's data which can sometimes cost you more than you can think. Whether to enable or disable a table lock depends upon your requirement. If you are allowing your users to delete or drop the table, then enable the table locks. If you only want them to perform DML (Data Manipulation Language) operations like INSERT, UPDATE or DELETE on the tables, then disable the table locks.
Table Locks are an important part of Oracle Working Mechanism as they provide security from unwanted deletion or modification of table's data which can sometimes cost you more than you can think. Whether to enable or disable a table lock depends upon your requirement. If you are allowing your users to delete or drop the table, then enable the table locks. If you only want them to perform DML (Data Manipulation Language) operations like INSERT, UPDATE or DELETE on the tables, then disable the table locks.
