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!

Partition by List and Sub-partition by Range (interval)

AkhleshApr 13 2017 — edited Apr 14 2017

I am trying to create a table partition by list and sub-partition by range (interval). But not able to do.

I know oracle support list-range partitioning, But i want to use interval clause at sub-partition level.

Can anybody answer whether it is possible or not, currently i am using oracle 12c.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 12 2017
Added on Apr 13 2017
4 comments
1,763 views