Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Safe to rename an oracle partition - oracle 11gr2?

user5716448Dec 24 2019 — edited Dec 26 2019

Hi,

HaveĀ  large oracle table and some code looks to rely on partition name matching name in calendar table.

Want to rename the partition name in large fact table - it also has local bitmap indexes

No data in these partitions yet.

ConSidering either drop the partition on the table itself and add new ones with correct name but woud prefer just to rename existing ones but don't want to make indexes unsuable

Is it safe to rename partitions on such a table?

Thanks

This post has been answered by Sunny kichloo on Dec 26 2019
Jump to Answer
Comments
Post Details
Added on Dec 24 2019
7 comments
177 views