Example - Setting an Interval Range Partition v13
The example that follows sets an interval range partition of the sales
table from range partitioning to start using monthly interval range partitioning. Use the following command to create the sales
table:
To set the interval range partitioning from the sales
table, invoke the following command:
Query the ALL_TAB_PARTITIONS
view before a database creates an interval range partition.
Now, add data to the sales
table that exceeds the high value of a range partition.
Then, 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.