Physical Attributes of Index Partitions

Default physical attributes are initially specified when a CREATE INDEX statement
creates a partitioned index. Because there is no segment corresponding to the
partitioned index itself, these attributes are only used in derivation of physical
attributes of member partitions. Default physical attributes can later be modified using
ALTER INDEX MODIFY DEFAULT ATTRIBUTES.
Physical attributes of partitions created by CREATE INDEX are determined as follows:
■ Values of physical attributes specified (explicitly or by default) for the index are used whenever the value of a corresponding partition attribute is not specified.
Handling of the TABLESPACE attribute of partitions of a LOCAL index constitutes
an important exception to this rule in that in the absence of a user-specified
TABLESPACE value (at both partition and index levels), that of the corresponding
partition of the underlying table is used.
■ Physical attributes (other than TABLESPACE, as explained in the preceding) of
partitions of local indexes created in the course of processing ALTER TABLE ADD
PARTITION are set to the default physical attributes of each index.
Physical attributes (other than TABLESPACE) of index partitions created by ALTER
TABLE SPLIT PARTITION are determined as follows:
■ Values of physical attributes of the index partition being split are used.
Physical attributes of an existing index partition can be modified by ALTER INDEX
MODIFY PARTITION and ALTER INDEX REBUILD PARTITION. Resulting attributes
are determined as follows:
■ Values of physical attributes of the partition before the statement was issued are
used whenever a new value is not specified. Note that ALTER INDEX REBUILD
PARTITION can be used to change the tablespace in which a partition resides.
Physical attributes of global index partitions created by ALTER INDEX SPLIT
PARTITION are determined as follows:
■ Values of physical attributes of the partition being split are used whenever a new
value is not specified.
■ Physical attributes of all partitions of an index (along with default values) may be modified by ALTER INDEX, for example, ALTER INDEX indexname NOLOGGING
changes the logging mode of all partitions of indexname to NOLOGGING.

Posted in: Index