Allows a database administrator to copy the metadata for
an existing table and create a new table with similar
characteristics. An optional column list can be used to add extra
columns and contraints to this table. The referenced table must
exist in the same database as the table being created.
Syntax options:
LOGGING | NOLOGGING
The LOGGING clause specifies that the CREATE TABLE statement
should be logged in the recovery-unit journal file (.ruj) and
after-image journal file (.aij).
The NOLOGGING clause specifies that the CREATE TABLE statement
should not be logged in the recovery-unit journal file (.ruj) and
after-image journal file (.aij).
The LOGGING clause is the default.