How Many Types of Tables Supported by Oracle?
SQL tutorial | Interview questions | Oracle :: Interview questions :: Oracle DBA Interview questions
Page 1 of 1
How Many Types of Tables Supported by Oracle?
Oracle supports 4 types of tables based on how data is organized in storage:
Ordinary (heap-organized) table - This is the basic, general purpose type of table. Its data is
stored as an unordered collection (heap)
Clustered table - A clustered table is a table that is part of a cluster. A cluster is a group of tables
that share the same data blocks because they share common columns and are often used
together.
Index-organized table - Unlike an ordinary (heap-organized) table, data for an index-organized
table is stored in a B-tree index structure in a primary key sorted manner. Besides storing the
primary key column values of an index-organized table row, each index entry in the B-tree stores
the nonkey column values as well.
Partitioned table - Partitioned tables allow your data to be broken down into smaller, more
manageable pieces called partitions, or even subpartitions. Each partition can be managed
individually, and can operate independently of the other partitions, thus providing a structure that
can be better tuned for availability and performance.
Ordinary (heap-organized) table - This is the basic, general purpose type of table. Its data is
stored as an unordered collection (heap)
Clustered table - A clustered table is a table that is part of a cluster. A cluster is a group of tables
that share the same data blocks because they share common columns and are often used
together.
Index-organized table - Unlike an ordinary (heap-organized) table, data for an index-organized
table is stored in a B-tree index structure in a primary key sorted manner. Besides storing the
primary key column values of an index-organized table row, each index entry in the B-tree stores
the nonkey column values as well.
Partitioned table - Partitioned tables allow your data to be broken down into smaller, more
manageable pieces called partitions, or even subpartitions. Each partition can be managed
individually, and can operate independently of the other partitions, thus providing a structure that
can be better tuned for availability and performance.
Similar topics
» What Are the ANSI Data Types Supported in Oracle?
» How Many Data Types Are Supported?
» What Are Transaction Isolation Levels Supported by Oracle?
» What Operating Systems Are Supported by Oracle SQL Developer?
» How To List All Tables in Your Schema?
» How Many Data Types Are Supported?
» What Are Transaction Isolation Levels Supported by Oracle?
» What Operating Systems Are Supported by Oracle SQL Developer?
» How To List All Tables in Your Schema?
SQL tutorial | Interview questions | Oracle :: Interview questions :: Oracle DBA Interview questions
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
Sun Jan 31, 2010 12:35 am by Micheal
» Accessing tables of other users in SQL
Sun Jan 31, 2010 12:34 am by Micheal
» Grouping commands in SQL
Sun Jan 31, 2010 12:32 am by Micheal
» Operations on Result Sets in SQL
Sun Jan 31, 2010 12:31 am by Micheal
» Subqueries in SQL
Sun Jan 31, 2010 12:30 am by Micheal
» Joining Relations in SQL
Sun Jan 31, 2010 12:28 am by Micheal
» Delete comand in SQL
Sun Jan 31, 2010 12:27 am by Micheal
» Update command in SQL
Sun Jan 31, 2010 12:26 am by Micheal
» Insert command in SQL
Sun Jan 31, 2010 12:23 am by Micheal