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 without a user-specified TABLESPACE
value (at both partition and index levels), the value of the physical attribute 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 during 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. The ALTER
INDEX
REBUILD PARTITION
SQL statement can 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
.
For more detailed examples of adding partitions and examples of rebuilding indexes, refer to Partition Administration.