René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback -
 

Tables in Oracle

The seven types of tables

There are seven types of tables in Oracle.

Heap organized tables

Index organized tables

Index clustered tables

Hash clustered tables

Nested tables

Global temporary tables

All data stored in a global temporary table is private to the session that has inserted (or updated) it. Other sessions can't see this data.
Global temporary tables come in two flavors: on commit preserve rows and on commit delete rows.
DDLs (such as drop table) on a on commit preserve rows lead to a ORA-14452 when the session has already made a DML on the table.

Object tables

An object table has one column that stores object types.

Reorganization of tables

Tables can be reorganized online