Example: Renaming a partition v16
This command creates a list-partitioned table named sales
:
Query the ALL_TAB_PARTITIONS
view to display the partition names:
This command renames the americas
partition to n_america
:
Query the ALL_TAB_PARTITIONS
view to show that the partition was successfully renamed: