Initial extent inconsistency
Hi,
I do not understand a thing about my database when I create OLTP compressed partitioned tables. Here is the example:
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
PL/SQL Release 11.2.0.2.0 - Production
CORE 11.2.0.2.0 Production
TNS for IBM/AIX RISC System/6000: Version 11.2.0.2.0 - Production
NLSRTL Version 11.2.0.2.0 - Production
SQL> CREATE TABLE LIZECHRI.TEST_FACT
2 (
3 C1 DATE,
4 C2 DATE,
5 C3 VARCHAR2(25 BYTE),
6 C4 VARCHAR2(25 BYTE),
7 C5 VARCHAR2(10 BYTE),
8 C6 VARCHAR2(10 BYTE),
9 C7 NUMBER(12),
10 C8 NUMBER(12),
11 DAT_DT DATE NOT NULL,
12 C10 VARCHAR2(3 BYTE) NOT NULL,
13 C11 VARCHAR2(3 BYTE) NOT NULL,
14 C12 VARCHAR2(10 BYTE) NOT NULL,
I do not understand a thing about my database when I create OLTP compressed partitioned tables. Here is the example:
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
PL/SQL Release 11.2.0.2.0 - Production
CORE 11.2.0.2.0 Production
TNS for IBM/AIX RISC System/6000: Version 11.2.0.2.0 - Production
NLSRTL Version 11.2.0.2.0 - Production
SQL> CREATE TABLE LIZECHRI.TEST_FACT
2 (
3 C1 DATE,
4 C2 DATE,
5 C3 VARCHAR2(25 BYTE),
6 C4 VARCHAR2(25 BYTE),
7 C5 VARCHAR2(10 BYTE),
8 C6 VARCHAR2(10 BYTE),
9 C7 NUMBER(12),
10 C8 NUMBER(12),
11 DAT_DT DATE NOT NULL,
12 C10 VARCHAR2(3 BYTE) NOT NULL,
13 C11 VARCHAR2(3 BYTE) NOT NULL,
14 C12 VARCHAR2(10 BYTE) NOT NULL,
0