RE: Do selects block truncates?
- From: Kurt Franke <Kurt-Franke@xxxxxx>
- To: 'oracle-l' <oracle-l@xxxxxxxxxxxxx>, ukja.dion@xxxxxxxxx
- Date: Fri, 21 Dec 2007 14:34:41 +0100
Hi,
...
>
> If select really blocks truncate, it's a amazing bug. :)
>
this is never a bug but is the consequence of enforcing statement-level read
consistency
which is always guranteed by oracle.
the only exception from this mechanism is the complete refresh of a
materialized view with
"atomic_refresh => FALSE" which then does the truncate wether or not any select
is runnig
on the materialized view. active select on the materialized view will break
then with
ORA-08103
regards
kf
--
//www.freelists.org/webpage/oracle-l
Other related posts:
