Rename operations in partitions and subpartitions are as easy as renaming tables  we just need to take care of syntax.

Rename Partitions :

We can see in above steps I have renamed Y_2013  partition of transaction table to Y_1_2013.

Rename Subpartition :

Same way we can rename a subpartition too. Let us see how.

We can see in above output A1  partition of DEPT_LIST_RANGE table to dept_25.

Rename index partition :

Let us see how we can rename index partition :

We can see in above output Y_2013  index partition is renamed as Y_Q_2013.

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Skant Gupta’s LinkedIn:

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

About The Author

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.