Home
Home 		Customize
Customize		 Help
Help 		Contact us
Contact Us

Virtual Book about 'index-organized table|iot'


Table of Contents: Virtual Book about 'index-organized table|iot'

This virtual book brings together the most relevant topics about 'index-organized table|iot'. The topics are grouped into these categories:
[Back to top]

Introductory Information about 'index-organized table|iot'

This category includes definitions, overviews, concepts, restrictions, frequently asked questions, and explanations of how things work. This is where you should start if you are not familiar with this subject area.

Results in this section come from these books:

[ Next book ]

Concepts

Index-Organized Tables

Table 10-4 Comparison of Index-Organized Tables with Ordinary Tables  

Benefits of Index-Organized Tables

Index-Organized Tables with Row Overflow Area

Secondary Indexes on Index-Organized Tables

Additional Features of Index-Organized Tables

Rebuilding an Index-Organized Table

Creating an Index-Organized Table in Parallel

Partitioning Index-Organized Tables and Their Secondary Indexes

Applications of Interest for Index-Organized Tables

Partitioning Index-Organized Tables and Their Secondary Indexes

Index-Organized Tables without Row Overflow

Index-Organized Tables with Row Overflow

Partitioned Secondary Indexes on Index-Organized Tables

Parallel Queries on Index-Organized Tables

Nonpartitioned Index-Organized Tables

Partitioned Index-Organized Tables

[ Previous book | Next book ]

Administrator's Guide

What are Index-Organized Tables

Why use Index-Organized Tables

[ Previous book | Next book ]

Application Developer's Guide - Fundamentals

Overview of Index-Organized Tables

Advantages of Index-Organized Tables

Features of Index-Organized Tables

[Next book]

Glossary

spatiotemporal data - Glossary

[Back to top]

Tasks Related to 'index-organized table|iot'

This category includes how-to information, both detailed procedures and general usage information and guidelines. The tasks are listed alphabetically, with shortcut links that jump to places within the list. For example, if you want to find Creating, look for a link labeled CRE.

Shortcuts to Tasks

ALT ANA CON CRE MAI MAN MOV PAR REB SPE USI

Altering Index-Organized Tables

Analyzing an Index-Organized Table

Analyzing Index-Organized Tables

Converting Index-Organized Tables to Regular Tables

Creating an Index-Organized Table in Parallel

Creating Index-Organized Tables

Creating Index-Organized Tables

Creating Secondary Indexes on Index-Organized Tables

Maintaining Index-Organized Tables

Manipulating Index-Organized Tables

Moving (Rebuilding) Index-Organized Tables

Moving Existing Data from an Ordinary Table into an Index-Organized Table

Partitioning an Index-Organized Table

Partitioning Index-Organized Tables and Their Secondary Indexes

Partitioning Index-Organized Tables and Their Secondary Indexes

Partitioning of Index-Organized Tables

Rebuilding an Index-Organized Table

Rebuilding an Index-Organized Table

Speeding Up Index Access with Index-Organized Tables

Using the ORDER BY Clause with Index-Organized Tables

[Back to top]

Examples of 'index-organized table|iot'

This category includes sample procedure and sample code, to illustrate how to perform tasks or use features.

Results in this section come from these books:

[ Next book ]

Concepts

Table 10-4 Comparison of Index-Organized Tables with Ordinary Tables  

[ Previous book | Next book ]

Administrator's Guide

Figure 13-1 Structure of Regular Table versus Index-Organized Table

[ Previous book | Next book ]

SQL Reference

Index-Organized Table Example - AS subquery

Index-Organized Table Examples - ALL TRIGGERS

[ Previous book | Next book ]

Application Developer's Guide - Fundamentals

Figure 6-1 Conventional Table and an Index versus Index-Organized Table

Figure 6-4 Range-partitioned Index-organized Table with Overflow Segment

[ Previous book | Next book ]

Application Developer's Guide - Large Objects (LOBs)

Example of Index Organized Table (IOT) with LOB Columns

[ Previous book | Next book ]

Application Developer's Guide - Object-Relational Features

Figure 5-6 Nested Table in IOT Storage

Figure 5-7 Nested Table in IOT Storage with Compression

[ Previous book | Next book ]

Supplied PL/SQL Packages

Table 16-1 DBMS_IOT Package Subprograms

[Back to top]

Detailed Reference Information on 'index-organized table|iot'

This category includes syntax for associated statements, APIs, or commands.

Results in this section come from these books:

[ Next book ]

Supplied PL/SQL Packages

DBMS_IOT

[Back to top]

Troubleshooting Information About 'index-organized table|iot'

This category includes information about debugging, preventing errors or handling them when they occur, frequently asked questions, and relevant error messages.

Results in this section come from these books:

[ Next book ]

Error Messages

ORA-01429 Index-Organized Table: no data segment to store overflow row-pieces

ORA-02031 no ROWID for fixed tables or for index-organized tables

ORA-02160 index-organized table can not contain columns of type LONG

ORA-12041 cannot record ROWIDs for index-organized table "string"."string"

ORA-12997 cannot drop primary key column from an index-organized table

ORA-24383 Overflow segment of an IOT cannot be described

ORA-25182 feature not currently available for index-organized tables

ORA-25183 index-organized table top index segment is in a different tablespace

ORA-25186 INCLUDING clause specified for index-organized table without OVERFLOW

ORA-25188 cannot drop/disable/defer the primary key constraint for index-organized tables

ORA-25189 illegal ALTER TABLE option for an index-organized table

ORA-25190 an index-organized table maintenance operation may not be combined with other operations

ORA-25191 cannot reference overflow table of an index-organized table

ORA-25192 invalid option for an index-organized table

ORA-25195 invalid option for index on an index-organized table

ORA-25198 only range partitioning is supported for index-organized table

ORA-25199 partitioning key of a index-organized table must be a subset of the primary key

ORA-26003 parallel load not supported for index-organized table string

ORA-28650 Primary index on an IOT cannot be rebuilt

ORA-28651 Primary index on IOTs can not be marked unusable

ORA-28658 This operation is supported only for Index-Organized tables

ORA-28660 Partitioned Index-Organized table may not be MOVEd as a whole

ORA-28662 IOT index and overflow segments must share the same LOGGING attribute

ORA-29866 cannot create domain index on a column of index-organized table

ORA-30560 SAMPLE option not allowed with index-organized tables

[Back to top]

Index Entries about 'index-organized table|iot'

The index entries show related terms, and identify the most important places where your subject is mentioned.
IO FL DB NE OB IN OR

Index Entries

DBMSIOTC.SQL script (Reference)
DBMS_IOT package (Supplied PL/SQL Packages)
flat IOT storage model (Time Series User's Guide)
index-organized table (Pro*COBOL Precompiler Programmer's Guide)
not used in power demand example (Data Cartridge Developer's Guide)
index-organized tables (Administrator's Guide)
     [entry #2] (Concepts)
     [entry #3] (Administrator's Guide)
     [entry #4] (Application Developer's Guide - Fundamentals)
     [entry #5] (Application Developer's Guide - Fundamentals)
     [entry #6] (Getting to Know Oracle8i)
applications (Concepts)
AS subquery (Administrator's Guide)
benefits (Concepts)
compatibility (Migration)
creating (Administrator's Guide)
     [subentry #2] (SQL Reference)
description (Administrator's Guide)
full table functionality (Getting to Know Oracle8i)
INCLUDING clause (Administrator's Guide)
inline storage for LOBs and (Application Developer's Guide - Large Objects (LOBs))
key compression (Administrator's Guide)
     [subentry #2] (Getting to Know Oracle8i)
key compression in (Concepts)
     [subentry #2] (Concepts)
LOB column support (Getting to Know Oracle8i)
logical ROWIDs (Getting to Know Oracle8i)
logical rowids (Concepts)
     [subentry #2] (Concepts)
maintaining (Administrator's Guide)
modifying (SQL Reference)
nested table data (Getting to Know Oracle8i)
overflow clause (Administrator's Guide)
parallel CREATE (Concepts)
parallel loading of (Getting to Know Oracle8i)
parallel queries (Concepts)
partition of (Concepts)
partitioned secondary indexes on (Concepts)
partitioning (Administrator's Guide)
     [subentry #2] (Getting to Know Oracle8i)
partitioning secondary indexes (Administrator's Guide)
queue tables (Concepts)
rebuild of (Concepts)
rebuilding (SQL Reference)
rebuilding with ALTER TABLE MOVE (Getting to Know Oracle8i)
rebuilding with MOVE clause (Administrator's Guide)
removing LOBs from (Migration)
removing partitions from (Migration)
row overflow area (Concepts)
rowids of (SQL Reference)
secondary indexes (Getting to Know Oracle8i)
secondary indexes on (Concepts)
storing nested tables as (Application Developer's Guide - Object-Relational Features)
threshold value (Administrator's Guide)
updating key column (Administrator's Guide)
IOT. (Administrator's Guide)
IOTs. See index-organized tables (Getting to Know Oracle8i)
nested IOT storage model (Time Series User's Guide)
object model (nested IOT storage) (Time Series User's Guide)
ORDTNumSeriesIOTRef data type (Time Series User's Guide)
ORDTNumSeriesIOTRef type (Time Series User's Guide)
ORDTVarchar2SeriesIOTRef data type (Time Series User's Guide)
[Back to top]

Bibliography

The links on this page lead to many different books. This section lists PDF files that you can download and print, if you want to do further reading. This section also identifies the relevant chapters that you can print out, rather than printing the entire book.

PDF FileMajor Topics to Print
Administrator's Guide
  • Index-Organized Tables
  • What are Index-Organized Tables
  • Maintaining Index-Organized Tables
Application Developer's Guide - Fundamentals
  • Speeding Up Index Access with Index-Organized Tables
  • Overview of Index-Organized Tables
  • Advantages of Index-Organized Tables
  • Example
Application Developer's Guide - Large Objects (LOBs)
  • LOBs in Index Organized Tables (IOT)
Application Developer's Guide - Object-Relational Features
  • Nested Table Storage
Concepts
  • Schema Objects
  • Index-Organized Tables
  • Additional Features of Index-Organized Tables
  • Rules for Partitioning Tables and Indexes
  • Partitioning Index-Organized Tables and Their Secondary Indexes
  • Parallel Query
  • Parallel Queries on Index-Organized Tables
Error Messages
Getting to Know Oracle8i
  • Partitioning Enhancements
Spatial User's Guide and Reference
  • Glossary
SQL Reference
  • ALL TRIGGERS
  • AS subquery
Supplied PL/SQL Packages
  • Summary of Subprograms
  • DBMS_IOT

Oracle
Copyright © 2025, Oracle and/or its affiliates. All rights reserved.