Partition And Exchange Agreement With Subpartitions Oracle In Texas
Description
Form popularity
FAQ
You cannot explicitly add a partition to an interval-partitioned table. The database automatically creates a partition for an interval when data for that interval is inserted.
You cannot explicitly add a partition to an interval-partitioned table. The database automatically creates a partition for an interval when data for that interval is inserted.
Subpartitioning—also known as composite partitioning—is the further division of each partition in a partitioned table.
EXCHANGE PARTITION command can exchange partitions in a LIST , RANGE or HASH partitioned table. The structure of the source_table must match the structure of the target_table in that both tables must have matching columns and data types. The data in the table must adhere to the partitioning constraints.
2.1 Partitioning Overview. Partitioning provides a technique to subdivide objects into smaller pieces. Partitioning allows a table, index, or index-organized table to be subdivided into smaller pieces, where each piece of such a database object is called a partition.
Composite range-hash partitioning partitions data using the range method, and within each partition, subpartitions it using the hash method. Composite range-hash partitioning provides the improved manageability of range partitioning and the data placement, striping, and parallelism advantages of hash partitioning.