摘要: 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 阅读全文
posted @ 2013-03-06 14:12 禹过天晴 阅读(134) 评论(0) 推荐(0) 编辑