Example: Deleting a partition v16
This example deletes a partition of the sales
table.
Create the sales
table:
Query the ALL_TAB_PARTITIONS
view to display the partition names:
Delete the americas
partition from the sales
table:
Query the ALL_TAB_PARTITIONS
view to show that the partition was successfully deleted: