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

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 7 2017

Added on Sep 7 2017

12 comments

3,631 views