Skip to Main Content
Forums

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!

Interval Partitioning and Subparititioning

user10566312Mar 22 2017 — edited Mar 22 2017

Let's say I have a table:

CREATE TABLE list_hash_tab (

  id           NUMBER,

  code         VARCHAR2(10),

  description  VARCHAR2(50),

  START_date DATE,

  END_DATE DATE

);

I would like to have Interval-Interval composite partitioning, i.e., interval partitioning on START_DATE and Interval subpartition on END_DATE.

Appreciate anyones help.

I am using Oracle 11g.
This post has been answered by Dejan T. on Mar 22 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 19 2017
Added on Mar 22 2017
3 comments
1,161 views