How to Implement Hash Partitioning on IOT Tables in 9i & Above
(Doc ID 165701.1)
Last updated on FEBRUARY 28, 2020
Applies to:Oracle Database - Enterprise Edition - Version 184.108.40.206 and later
Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
This article will present the Oracle 9i functionality of partitioning Index Organized Tables (IOT) with Hash algorithm.
In previous versions, only Range partitioning was available on IOTs.
This article is designed for DBAs, which have already knowledge on IOTs structure, and partitioning capabilities in 8.0 and 8i versions.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!