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