Skip to Main Content
  • Questions
  • Why are Index Organized tables (IOTs) not supported by interval partitioning

Breadcrumb

Question and Answer

Chris Saxon

Thanks for the question.

Asked: March 04, 2019 - 10:47 am UTC

Last updated: March 04, 2019 - 11:17 am UTC

Version: 11g

Viewed 1000+ times

You Asked

Hi tom,

Could you please let me know why we can not use interval partitioning on index organized tables.

Thanks in advance

and Chris said...

Because we've not implemented that yet!

On a related note, you can't interval partition global indexes either:

create table t (
  c1 int
);

create index i on t ( c1  ) 
  global partition by range ( c1 ) 
  interval ( 1 ) (
  partition p0 values less than ( 0 )
);

ORA-00906: missing left parenthesis

create index i on t ( c1  ) 
  global partition by range ( c1 ) (
  partition p0 values less than ( 0 ),
  partition pmax values less than ( maxvalue )
);

select index_name, partitioning_type  
from   user_part_indexes;

INDEX_NAME   PARTITIONING_TYPE   
I            RANGE    


If you'd like to see interval partitioning support for IOTs and global indexes, add a request on the Database Ideas forum:

https://community.oracle.com/community/groundbreakers/database/database-ideas

Is this answer out of date? If it is, please let us know via a Comment

More to Explore

Administration

Need more information on Administration? Check out the Administrators guide for the Oracle Database