René Nyffenegger's collection of things on the web | |
René Nyffenegger on Oracle - Most wanted - Feedback
- Follow @renenyffenegger
|
Tables in Oracle | ||
The seven types of tables
There are seven types of tables in Oracle.
Heap organized tablesIndex organized tablesIndex clustered tablesHash clustered tablesNested tablesGlobal 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
|