--设置系统参数
alter system set deferred_segment_creation=false;
Select 'alter table '||table_name||' allocate extent;' from user_tables where num_rows=0 or num_rows is null;
--设置系统参数
alter system set deferred_segment_creation=false;
Select 'alter table '||table_name||' allocate extent;' from user_tables where num_rows=0 or num_rows is null;
转载于:https://www.cnblogs.com/Stir-friedEggplant/p/10578860.html