Monday, September 12, 2011

Types of tables in oracle

There are seven types of tables:

1. Heap organized tables:

A heap-organized table is a table with rows stored in no particular order. This is a standard Oracle table; the term "heap" is used to differentiate it from an index-organized table or external table.If a row is moved within a heap-organized table, the row's ROWID will also change.

Ex.
CREATE TABLE t1 (c1 NUMBER PRIMARY KEY, c2 VARCHAR2(30)) organization heap;

2.Index organized tables:

Index Organized Tables are tables that, unlike heap tables, are organized like B*Tree indexes. Besides storing the primary key values of an Oracle indexed-organized tables row, each index entry in the B-tree also stores the non-key column values.


Index clustered tables


Hash clustered tables


Nested tables


Global temporary tables

Object tables