Example - Deleting a Partition v13
The example that follows deletes a partition of the sales
table. Use the following command to create the sales
table:
Querying the ALL_TAB_PARTITIONS
view displays the partition names.
To delete the americas partition from the sales
table, invoke the following command:
Querying the ALL_TAB_PARTITIONS
view demonstrates that the partition has been successfully deleted.