设置deferred_segment_creation 参数
SQL>show parameter deferred_segment_creation
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
deferred_segment_creation boolean TRUE
SQL> alter system set deferred_segment_creation=false;
改变后只对之后的表起作用,并且需要重启oracle服务才能生效
SQL>show parameter deferred_segment_creation
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
deferred_segment_creation boolean TRUE
SQL> alter system set deferred_segment_creation=false;
改变后只对之后的表起作用,并且需要重启oracle服务才能生效