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