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!

List partition with range interval subpartition

vpolasaDec 8 2014 — edited Dec 8 2014

I'm trying to create a table with List partition and Range Interval subpartition. Is this achievable? I'm trying the below create statement but seeing the error:

create table mi_entities_p

(enty_key number,

fmly_key number)

partition by list (fmly_key)

subpartition by range (enty_key)

interval (1000000)

(partition p1 values (1)

(subpartition p_empty values less than (0))

);

SQL Error: ORA-00922: missing or invalid option

00922. 00000 - "missing or invalid option"

Using Oracle 11g in Windows 7.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 5 2015

Added on Dec 8 2014

4 comments

5,781 views