Oracle Table Types

Oracle supports variety of table types and some of them includes , but not limited to:

• Heap organized: The default and most commonly used one.
• Temporary: Program needs a temporary table structure to store and sort data; temporary table isn’t required after program ends.
• Index organized: Data stored in a B-tree index structure sorted by primary key and provides fast random access.
• Partitioned: A logical table that consists of separate physical segments and used with large tables with millions of rows.
• External: Tables that use data stored in OS files outside the database and enables us to efficiently access data in a file outside the database,
• Clustered: A group of tables that share the same data blocks and used to reduce I/O for tables that are
  often joined on the same column.
• Hash Clustered: A table with data that is stored and retrieved using a hash function.
• Nested:  A table with a column with a data type that is another table and rarely used.
• Object: A table with a column with a data type that is an object type.