select table_name ,NUM_ROWS from user_tables where NUM_ROWS=0 or NUM_ROWS is null ;
select 'alter table '||table_name||' allocate extent;' from user_tables where num_rows=0 or NUM_ROWS is null
select table_name ,NUM_ROWS from user_tables where NUM_ROWS=0 or NUM_ROWS is null ;
select 'alter table '||table_name||' allocate extent;' from user_tables where num_rows=0 or NUM_ROWS is null
转载于:https://www.cnblogs.com/super-admin/p/6952103.html