Teradata locks - How to find if a table is locked?
Scenario: Is there a way to know if a table is locked and what kind of lock is currently on a table?
We can do something like the following:
Lock Table dbName.myTable for Access nowait Select * from dbName.myTable;
If the table is locked, you will get error 7423, "Object already locked and NOWAIT. Transaction Aborted."
Read great educational content like this and a lot more !
Members get free exclusive access to content, new courses, and discounts. Signup for a free account to write a post / comment / upvote posts. Creating an account takes less than 5 seconds and you can start earning badges & points too