select ‘alter table ‘||table_name||’ allocate extent;’ from user_tables t where t.NUM_ROWS = 0 or t.NUM_ROWS is null;