查询select table_name from user_tables where NUM_ROWS=0;
select 'alter table '||table_name||' allocate extent;' from user_tables where num_rows=0
将结果改为 alter table BCG_DATA allocate extent;
查询select table_name from user_tables where NUM_ROWS=0;
select 'alter table '||table_name||' allocate extent;' from user_tables where num_rows=0
将结果改为 alter table BCG_DATA allocate extent;
转载于:https://my.oschina.net/u/566324/blog/353886