select 'alter table '||table_name||' allocate extent(size 64k);' sql_text,table_name,tablespace_name
from user_tables where table_name not in (select segment_name from user_segments where segment_type = 'TABLE');
from user_tables where table_name not in (select segment_name from user_segments where segment_type = 'TABLE');