RE: Truncate table - interaction with a long running query
- From: "Baumgartel, Paul" <paul.baumgartel@xxxxxxxxxxxxxxxxx>
- To: "'peter.schauss@xxxxxxx'" <peter.schauss@xxxxxxx>, oracle-l@xxxxxxxxxxxxx
- Date: Wed, 15 Aug 2007 19:01:52 +0100
Truncate should require an exclusive lock, which would be incompatible with the
row share lock held by the query; therefore the truncate should block (or
automatically time out after 5 minutes, depending on version I think) until the
query is complete.
Paul Baumgartel
CREDIT SUISSE
Information Technology
Securities Processing Databases Americas
One Madison Avenue
New York, NY 10010
USA
Phone 212.538.1143
paul.baumgartel@xxxxxxxxxxxxxxxxx
www.credit-suisse.com
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Schauss, Peter
Sent: Wednesday, August 15, 2007 1:15 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Truncate table - interaction with a long running query
If one process attempts to truncate a table while another process is
accessing it in a long running query, what happens? (Oracle 8.1.7.4)
Thanks,
Peter Schauss
--
//www.freelists.org/webpage/oracle-l
==============================================================================
Please access the attached hyperlink for an important electronic communications
disclaimer:
http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
==============================================================================
--
//www.freelists.org/webpage/oracle-l
Other related posts:
