Example: Setting an interval range partition v16
This example sets an interval range partition of the sales
table. It converts the table from range partitioning to start using monthly interval range partitioning.
This command creates the sales
table:
Set the interval range partitioning from the sales
table:
Query the ALL_TAB_PARTITIONS
view before a database creates an interval range partition:
Add data to the sales
table that exceeds the high value of a range partition:
Query the ALL_TAB_PARTITIONS
view again after the INSERT
statement. The interval range partition is successfully created and data is inserted. A system-generated name of the interval range partition is created that varies for each session.