select table_name from user_tables where NUM_ROWS=0;
查询出来所以空表,然后执行extent
alter table TBL_TIANTUO_GZJH_ATTACH allocate extent;
如果表多:
select 'alter table '||table_name||' allocateextent;' from user_tables where num_rows=0
生成sql语句
select ' alter table '|| a.table_name ||' allocate extent;'
from user_tables a
where a.table_name not in
(select segment_name
from user_segments
where segment_type = 'TABLE');