Skip to Main Content
  • Questions

  • How to create global partitioned Index with different partition structure as underlying list partitioned table

Breadcrumb

Question and Answer

Chris Saxon

Thanks for the question, Thomas.

Asked: August 10, 2017 - 10:44 am UTC

Last updated: August 10, 2017 - 3:35 pm UTC

Version: 12.1

Viewed 1000+ times

You Asked

Hello together !

Today I run in issues if I try to create a global list partitioned Index on a list partitioned table. I would like to have a different partitioning structure on the index.
I see some examples in the web with Hash partitioning. But seems not to work for List Partitioning ?


Best regards,
Thomas

with LiveSQL Test Case:
https://livesql.oracle.com/apex/livesql/file/content_FEET20B3132HCWCPRTNFR0AW0.html

and Chris said...

That's because you can't have global list partitioned indexes!

"Oracle offers global range partitioned indexes and global hash partitioned indexes, discussed in the following topics:"

http://docs.oracle.com/database/122/VLDBG/partition-concepts.htm#VLDBG1075


Rating

  (1 rating)

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

Comments

Thanks a lot

Thomas Hilke, August 11, 2017 - 6:11 am UTC


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.