Uncovering Oracle’s Massive CREATE TABLE Docs: Core Database Concepts Explained

Step 1 – Core Oracle Database Objects

Oracle’s data dictionary contains a small set of schema objects that underlie virtually every SQL statement. Understanding these objects is essential before tackling the extensive CREATE/ALTER TABLE syntax.

Table

Physical container for rows and columns. Each table belongs to a tablespace, which maps the logical storage to one or more data files on disk.

Index

Optional schema object that stores a copy of selected column values in a structure (B‑tree, bitmap, etc.) to accelerate row lookup. Indexes are the primary tool for SQL performance tuning.

Sequence

Standalone object that generates a monotonically increasing (or decreasing) numeric series. Used to supply surrogate primary‑key values without locking the target table.

View

Virtual table defined by a SELECT query. The view does not store data; it derives rows at query time, enabling column‑level security and simplifying complex joins.

Cluster

Physical storage structure that co‑locates rows from two or more tables that share common columns on the same data blocks. This reduces I/O for frequent multi‑table joins.

Database

Logical collection of schema objects (tables, indexes, etc.) managed by a single Oracle instance. An instance can access only one database at a time.

Tablespace

Logical storage unit that groups related data files. Objects are created in a tablespace, allowing the underlying files to be moved or resized without altering object definitions.

Database Link

Named object that stores connection information to a remote Oracle database. Enables distributed SQL statements that reference objects in another database.

Synonym

Alias for any schema object (table, view, sequence, etc.). Provides location transparency and decouples application code from the object's actual owner or location.

These objects have been part of Oracle since early releases (e.g., Oracle 7) and have been extended in later versions such as 11g and 12c. For a complete reference, consult the Oracle Database Concepts manual and experiment with DDL statements like CREATE TABLE …, CREATE INDEX …, CREATE SEQUENCE …, etc.