RE: Do selects block truncates?

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

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