Skip to Main Content

SQL & PL/SQL

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!

Alter Daily partitioned table to monthly partition

snraoSep 7 2017 — edited Sep 9 2017

Hi....

Can anybody help me provide steps to follow to alter the existing daily partitioned table into monthly partitioned table in oracle database 11.2.0.2 version (table should have same name)?

Note : I don't have access to use oracle special packages like dbms_redefinition etc and i also have indexes present on the table. please let me know if any adhoc way  to do this.

response would be really appreciated...!!

Thanks..!!

This post has been answered by Nimish Garg on Sep 7 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 7 2017
Added on Sep 7 2017
12 comments
3,616 views