Re: merge tables and table locks
The write lock of the base table will only write lock the base table.
However, the Select on the Merge table will have to get the read lock on all the base table before it can execute, so the write lock on the base table will still block the read lock on the merge table.
Subject
Views
Written By
Posted
7371
March 13, 2007 04:17PM
Re: merge tables and table locks
4798
March 13, 2007 08:46PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.