Split Partition Is Losing Nologging Attribute On Index Subpartitions (Doc ID 1366391.1)

Last updated on MARCH 27, 2014

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.4 and later   [Release: 10.2 and later ]
Information in this document applies to any platform.

Symptoms

Consider the following table and index created with the NOLOGGING attribute.


CREATE TABLE ACCOUNTING
(
PART_KEY NUMBER DEFAULT null NOT NULL,
SESSION_KEY CHAR(36) NOT NULL,
REC_SEQUENCE NUMBER(38,0) NOT NULL,
AP_TIME_STAMP DATE NULL,
GRP_KEY NUMBER(38,0) NULL
)
ORGANIZATION HEAP
TABLESPACE USERS
NOLOGGING
NOCACHE
NOROWDEPENDENCIES
PARTITION BY RANGE(PART_KEY)
SUBPARTITION BY LIST(GRP_KEY)
SUBPARTITION TEMPLATE
(SUBPARTITION SPREST VALUES (0),
SUBPARTITION SPINT VALUES (1),
SUBPARTITION SPFS1 VALUES (2),
SUBPARTITION SPFS2 VALUES (3),
SUBPARTITION SPFS20 VALUES (4))
(PARTITION P20110920 VALUES LESS THAN (20110921)
TABLESPACE USERS
PCTFREE 1
INITRANS 8
MAXTRANS 255
NOLOGGING
(SUBPARTITION P20110920_SPREST VALUES(0) TABLESPACE USERS,
SUBPARTITION P20110920_SPINT VALUES(1) TABLESPACE USERS,
SUBPARTITION P20110920_SPFS20 VALUES(2) TABLESPACE USERS),
PARTITION P_MAXVALUE VALUES LESS THAN (MAXVALUE)
TABLESPACE USERS
PCTFREE 1
INITRANS 8
MAXTRANS 255
NOLOGGING
(SUBPARTITION P_MAXVALUE_SPREST VALUES(0) TABLESPACE USERS,
SUBPARTITION P_MAXVALUE_SPINT VALUES(1) TABLESPACE USERS,
SUBPARTITION P_MAXVALUE_SPFS1 VALUES(2) TABLESPACE USERS,
SUBPARTITION P_MAXVALUE_SPFS2 VALUES(3) TABLESPACE USERS,
SUBPARTITION P_MAXVALUE_SPFS19 VALUES(4) TABLESPACE USERS,
SUBPARTITION P_MAXVALUE_SPFS20 VALUES(5) TABLESPACE USERS))
ENABLE ROW MOVEMENT
/



CREATE INDEX ACCOUNTING_IDX1
ON ACCOUNTING(AP_TIME_STAMP)
TABLESPACE USERS
NOLOGGING
PCTFREE 10
INITRANS 5
MAXTRANS 255
STORAGE(BUFFER_POOL DEFAULT)
NOPARALLEL
LOCAL
/


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms