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 - 12 of 12 Answers

anil

  • 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

anil

  • 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

doc123

  • 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