The index entries for the FAL_WIN_2007 partition will now reside in two new partitions, FAL_
2007 and WIN_2008.
Renaming a Local Index Partition Most characteristics of a local index are updated
automatically when the corresponding table partition is modified. However, a few operations still
may need to be performed on a local index partition, such as rebuilding the partition or renaming
a partition that was originally named with a default system-assigned name. In this example, you
Partition
Operation
Index Type Range Hash/List Composite
Add a partition Global N/A ADD PARTITION
(hash)
N/A
Local N/A N/A N/A
Drop a partition Global DROP PARTITION N/A N/A
Local N/A N/A N/A
Modify default
attributes
Global MODIFY DEFAULT
ATTRIBUTES
N/A N/A
Local MODIFY DEFAULT
ATTRIBUTES
MODIFY
DEFAULT
ATTRIBUTES
MODIFY DEFAULT
ATTRIBUTES [FOR
PARTITION]
Modify real
attributes
Global MODIFY PARTITION N/A N/A
Local MODIFY PARTITION MODIFY
PARTITION
MODIFY
[SUB]PARTITION
Rebuild a partition Global REBUILD PARTITION N/A N/A
Local REBUILD PARTITION REBUILD
PARTITION
REBUILD
SUBPARTITION
Rename a partition Global RENAME PARTITION N/A N/A
Local RENAME PARTITION RENAME
PARTITION
RENAME
[SUB]PARTITION
Split a partition Global SPLIT PARTITION N/A N/A
Local N/A N/A N/A
TABLE 16-7 Maintenance Operations for Partitioned Indexes
582 Oracle Database 11g DBA Handbook
will rename the local index partitions in the index OE.
Pages:
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862