Oracle 11g can not exp table without rows

来源:互联网 发布:网络违法犯罪举报app 编辑:程序博客网 时间:2024/06/03 19:49

SOLUTION:

1>alter system set deferred_segment_creation=false scope=both;--can not influence the table before changing this parameter.

2>select 'altertable '||table_name||' allocate extent;' from user_tables;