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');

1万+

被折叠的 条评论
为什么被折叠?



