Example - INTERVAL RANGE PARTITION v12
The following example shows a (sales)
table that is partitioned by interval on the sold_month
column. The range partition is created to establish a transition point and new partitions are created beyond that transition point. The database creates a new interval range partition and adds data into a table.
First, query the ALL_TAB_PARTITIONS
view before an interval range partition is created by the database.
Now, insert data into a sales
table that exceeds the high value of a range partition.
Then, query the ALL_TAB_PARTITIONS
view again after the insert. The data is successfully inserted and a system generated name of the interval range partition is created that varies for each session.