--更改空表
select 'alter table ' ||table_name||' allocate extent(size 64k);'
from tabs t
where not exists (select segment_name
from user_segments s
where s.segment_name = t.TABLE_NAME)
--查询表字段名
SELECT t.column_name,t.TABLE_NAME FROM All_Tab_Columns t WHERE t.COLUMN_NAME LIKE '%UNITSEQ%'
