1、

ALTER SYSTEM SET deferred_segment_creation=FALSE SCOPE=MEMORY;

ALTER SYSTEM SET deferred_segment_creation=FALSE SCOPE=SPFILE;

alter system set processes=400 scope=spfile;

2、

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