Partition And Exchange Agreement With Subpartitions Oracle In Hillsborough
Description
Form popularity
FAQ
Subpartitioning—also known as composite partitioning—is the further division of each partition in a partitioned table.
Use the ALTER TABLE ADD PARTITION statement to add a new partition to the "high" end (the point after the last existing partition). To add a partition at the beginning or in the middle of a table, use the SPLIT PARTITION clause.
Partitioning-related clauses for ALTER TABLE can be used with partitioned tables for repartitioning, to add, drop, discard, import, merge, and split partitions, and to perform partitioning maintenance.
Range partitioning is a convenient method for partitioning historical data. The boundaries of range partitions define the ordering of the partitions in the tables or indexes. Interval partitioning is an extension to range partitioning in which, beyond a point in time, partitions are defined by an interval.
Subpartitioning—also known as composite partitioning—is the further division of each partition in a partitioned table.
You cannot explicitly drop a partition from a local index. Instead, local index partitions are dropped only when you drop a partition from the underlying table.
Use the ALTER TABLE ADD PARTITION statement to add a new partition to the "high" end (the point after the last existing partition). To add a partition at the beginning or in the middle of a table, use the SPLIT PARTITION clause.