Heap-organized table

From Oracle FAQ
Jump to: navigation, search

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.

[edit] Examples

CREATE TABLE t1 (c1 NUMBER PRIMARY KEY, c2 VARCHAR2(30));
CREATE TABLE t1 (c1 NUMBER PRIMARY KEY, c2 VARCHAR2(30)) ORGANIZATION HEAP;

[edit] Also see

Glossary of Terms
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z #