zbb20170606 oracle 查看空表

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