Maintaining Index Partitions To maintain one or more index partitions or subpartitions, you
use the alter index command just as you would on a nonpartitioned index. Table 16-7 lists the
types of partitioned index operations and the keywords you would use to perform them for the
different types of partitioned indexes (range, hash, list, and composite). The format of the alter
index command is
alter index
;
As with table partition maintenance commands, not all operations are available for every
index partition type. You should note that many of the index partition maintenance options do
not apply to local index partitions. By its nature, a local index partition matches the partitioning
scheme of the table and will change when you modify the table??™s partitioning scheme.
Splitting a Global Index Partition Splitting a global index partition is much like splitting a
table??™s partition. One particular global index partition may be a hotspot due to the index entries
Chapter 16: Managing Large Databases 581
being stored in that particular partition; as with a table partition, you can split the index partition
into two or more partitions. In the following example, you??™ll split one of the partitions of the
global index OE.CAT_REQ_DT_IX into two partitions:
SQL> alter index oe.cat_req_dt_ix split partition
2 fal_win_2007 at (to_date('20071201','YYYYMMDD')) into
3 (partition fal_2007 tablespace idx_7,
4 partition win_2008 tablespace idx_8);
Index altered.
Pages:
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861