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!

Determine partition range start and stop for a partition

user5716448Apr 10 2013 — edited Apr 11 2013

Hi,

Using oracle 11.2.0.3

We are using range interval partitioning and partition sget generated automatically. (range-hash) intervbal 1 month

Whilst can check table manually and see start and end range of partition is it possible to query data dictionary to see
the satrt and stop range as wish to have script to automatically rename the system generated partitions based on the range involved e.g if generated partition has max date value

3062013 waoul want PART_201306

Thanks

This post has been answered by unknown-7404 on Apr 11 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on May 9 2013

Added on Apr 10 2013

#general-database-discussions

5 comments

579 views