HI,
Using oracle 11.2.0.3 and have a composite range-interval has partitioned table 1 partition per month, 4 sub-partitions per partition
Plan to rename the system-generated names to something more meaningful.
alter table <table_name> rename partition <sys...> to <PART_YYYYMM>
Anything we should be aware of - looks like indexes stay valid after rename operations - is this the case - just want to ensure nothing which haven't foreseen in terms of rename opertaions.
Thanks