|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
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
An object table has one column that stores object types.
Reorganization of tables
Tables can be reorganized online