select table_name from user_tables where NUM_ROWS=0; select 'alter table '||table_name||' allocate extent;' from user_tables where num_rows=0;
转载于:https://www.cnblogs.com/boazy/archive/2013/03/31/2992575.html
select table_name from user_tables where NUM_ROWS=0; select 'alter table '||table_name||' allocate extent;' from user_tables where num_rows=0;
转载于:https://www.cnblogs.com/boazy/archive/2013/03/31/2992575.html