When the new quarter starts,
a new partition is created, and the oldest partition is archived and dropped. In the following
example, you will split the last partition of the CAT_REQ table you created earlier in this chapter
578 Oracle Database 11g DBA Handbook
Partition
Operation
Composite *-Range Composite *-Hash Composite *-List
Add a
subpartition
MODIFY
PARTITION ??¦ ADD
SUBPARTITION
MODIFY PARTITION ??¦ ADD
SUBPARTITION
MODIFY PARTITION ??¦
ADD SUBPARTITION
Coalesce a
subpartition
N/A MODIFY PARTITION ??¦
COALESCE SUBPARTITION
N/A
Drop a
subpartition
DROP
SUBPARTITION
N/A DROP SUBPARTITION
Exchange a
subpartition
EXCHANGE
SUBPARTITION
N/A EXCHANGE
SUBPARTITION
Merge
subpartitions
MERGE
SUBPARTITIONS
N/A MERGE SUBPARTITIONS
Modify default
attributes
MODIFY DEFAULT
ATTRIBUTES FOR
PARTITION
MODIFY DEFAULT ATTRIBUTES
FOR PARTITION
MODIFY DEFAULT
ATTRIBUTES FOR
PARTITION
Modify real
attributes
MODIFY
SUBPARTITION
MODIFY SUBPARTITION MODIFY SUBPARTITION
Modify list
subpartitions:
Add values
N/A N/A MODIFY SUBPARTITION
??¦ ADD VALUES
Modify List
subpartitions:
drop values
N/A N/A MODIFY SUBPARTITION
??¦ DROP VALUES
Move a
subpartition
MOVE
SUBPARTITION
MOVE SUBPARTITION MOVE SUBPARTITION
Rename a
subpartition
RENAME
SUBPARTITION
RENAME SUBPARTITION RENAME SUBPARTITION
Split a
subpartition
SPLIT
SUBPARTITION
N/A SPLIT SUBPARTITION
Truncate a
subpartition
TRUNCATE
SUBPARTITION
TRUNCATE SUBPARTITION TRUNCATE
SUBPARTITION
TABLE 16-6 Maintenance Operations for Subpartitions of Partitioned Tables
at a specific date and maintain the new partition with maxvalue, back up the oldest partition, and
then drop the oldest partition.
Pages:
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858