Locks in Oracle

A user issues the below query,
1. Select * from table1 lock table
At the same time DBA is trying to modify this table table1 using alter command, will he able to do that or not?

Questions by zefyrpma

Showing Answers 1 - 4 of 4 Answers


  • Dec 13th, 2011

No we cant do if table lock

  Was this answer useful?  Yes

rohan makode

  • Feb 25th, 2012

No because dba is updating the table so it is not possible.

  Was this answer useful?  Yes


  • Mar 13th, 2012

there dba can break the lock given to table.
but in real time, no dba has the right to break the lock given by the user

  Was this answer useful?  Yes


  • Mar 22nd, 2012

DDL lock are exclusive locks. It shared the data. Means anyone can select data from same table.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions