Perform an experiment where the initial value is smaller than the uniform size. After the table is created, the extents of minextents uniform size are created., minextentsextents

Perform an experiment where the initial value is smaller than the uniform size. After the table is created, the extents of minextents uniform size are created., minextentsextents

Perform an experiment where the initial is smaller than the uniform size to verify that after the table is created, the extents of minextents uniform size are created.

Related Knowledge reference: http://blog.csdn.net/msdnchina/article/details/43836411

Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL> alter system set deferred_segment_creation=false;System altered.SQL> show parameter deferNAME                                 TYPE        VALUE------------------------------------ ----------- ------------------------------deferred_segment_creation            boolean     FALSESQL> create tablespace test_uni_sz_2m    2  datafile '/u01/app/oracle/oradata/test/test_uni_sz_2m_01.dbf' size 50m    3  extent management local uniform size 2m;  Tablespace created.SQL> create table test_tab_2 (col1 varchar2(2)) tablespace test_uni_sz_2m storage(initial 65535 minextents 3);Table created.SQL> select bytes from dba_extents where segment_name = 'TEST_TAB_2' and owner = 'SCOTT';       BYTES----------   2097152   2097152   2097152SQL> show userUSER is "SCOTT"SQL>