Skip to Main Content
  • Questions

  • Can we partition a index organized table?

Breadcrumb

We're taking a break this week as Connor and Chris will both be at CloudWorld, the premier Oracle conference of 2024. If you're in Vegas, please come say Hi or pop into our sessions

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

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

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.