select 'alter table '||table_name||' allocate extent;' from user_tables where num_rows=0 转载于:https://www.cnblogs.com/Leechg/p/9501008.html