Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Do selects block truncates?

RE: Do selects block truncates?

From: <genegurevich_at_discover.com>
Date: Fri, 21 Dec 2007 09:49:34 -0600
Message-ID: <OFEC1252C7.AF87D0A9-ON862573B8.0056C3C9-862573B8.0056EFA8@discover.com> 





All:



I have received an Email from someone on this list (it went directly to me)
which seems to provide another explanation:



"A SELECT needs to hold a TM enqueue when it is
running so that the data structure does not change underneath it when
it is running due to DDL (including TRUNCATE which is considered DDL)"



thank you very much to all who replied



Gene Gurevich



--
http://www.freelists.org/webpage/oracle-l


Received on Fri Dec 21 2007 - 09:49:34 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US