Partition And Exchange Agreement With Subpartitions Oracle In Arizona
Description
Form popularity
FAQ
Example: HASH/RANGE PARTITIONS num... You can extend the PARTITION BY HASH clause to include SUBPARTITION BY either RANGE | LIST | HASH to create subpartitions in a HASH partitioned table. This example creates a table sales that's hash partitioned by part_no and subpartitioned using a range by dept_no .
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.
After selecting the partitioning column and any other options, select Next. On the Select a Partition Function page, under Select partition function, select either New partition function or Existing partition function. If you choose New partition function, enter the name of the function.