Example: Setting an AUTOMATIC list partition v16
This example modifies a table sales
to use automatic list partitioning instead of regular list partitioning.
This command creates a sales
table:
Implement automatic list partitioning on the sales
table:
Query the ALL_TAB_PARTITIONS
view to show that an existing partition is successfully created:
Insert data into the sales
table to create a partition and add the value:
Query the ALL_TAB_PARTITIONS
view again after the insert. The automatic list partition is successfully created and data is inserted. A system-generated name of the partition is created that varies for each session.