Skip to Main Content
  • Questions
  • Can we partition a index organized table?

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Dilip.

Asked: July 31, 2024 - 2:24 am UTC

Last updated: August 05, 2024 - 7:18 am UTC

Version: Oracle 19C

Viewed 100+ times

You Asked

Can we partition a index organized table?

and Connor said...

Yes you can


SQL> create table t ( x int primary key , y int )
  2  organization index
  3  partition by hash ( x ) partitions 8;

Table created.

SQL> create table t ( x int primary key , y int )
  2  organization index
  3  partition by range ( x )
  4  ( partition p1 values less than (1000),
  5    partition p2 values less than (maxvalue));

Table created.



We're not taking comments currently, so please try again later if you want to add a comment.

More to Explore

VLDB

If you are new to partitioning, check out Connor McDonald's introduction series here.

VLDB

Documentation set on VLDB and Partitioning.