王星乐的博客

Select 'alter table '||table_name||' allocate extent;' from user_tables where num_rows=0

select 'alter table '|| t.table_name||' disable constraint '||t.constraint_name||';' from user_constraints t where t.constraint_type = 'R' order by t.table_name select 'alter table '|| t.table