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