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!

How to find partioning_type – range or interval?

user632098May 1 2009 — edited May 3 2009
I have a table which is interval partitioned. It has several range partitions and several interval partitions. Is there any way to find which partitions are range and which are interval. I looked in user_part_tables, it does not give me all partitions of the table. User_tab_partitions shows me all partitions, but does not tell partitioning_type.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 31 2009
Added on May 1 2009
11 comments
7,193 views