Name
CREATE/ALTER/DROP TABLE (Relational Syntax)
Synopsis
CREATE Syntax:
CREATE [GLOBAL] [TEMPORARY] TABLE [schema
.]table_name
(column
datatype
[DEFAULTexpr
] [Column_Constraint_Clause
] [,column
datatype
[DEFAULTexpr
] [Column_Constraint_Clause
]...] [Table_Constraint_Clause
]) [ON COMMIT {DELETE | PRESERVE} ROWS] [Physical_Attributes_Clause
] [TABLESPACEtablespace_name
] [Storage_Clause
] [{LOGGING | NOLOGGING}] [{COMPRESS | NOCOMPRESS}] { CLUSTER (column
[,column
...]) | ORGANIZATION HEAP [Physical_Attributes_Clause
] [TABLESPACEtablespace_name
] [Storage_Clause
] [{LOGGING | NOLOGGING}] [{COMPRESS | NOCOMPRESS}] | ORGANIZATION INDEX [Physical_Attributes_Clause
] [TABLESPACEtablespace_name
] [Storage_Clause
] [{LOGGING | NOLOGGING}] { {MAPPING TABLE | NOMAPPING} | PCTTHRESHOLDinteger
| {COMPRESSinteger
| NOCOMPRESS} } [[INCLUDINGcolummn
] OVERFLOW [Physical_Attributes_Clause] [TABLESPACE tablespace_name] [Storage_Clause] [LOGGING | NOLOGGING] | ORGANIZATION EXTERNAL ([TYPE access_data_type] DEFAULT DIRECTORY directory [ACCESS PARAMETERS {(opaque_format_spec) | USING CLOB subquery}] LOCATION ([directory:]'location_specifier' [,[directory:]'location_specifier']) [REJECT LIMIT {integer | UNLIMITED}] } [Partition_Clause] { [ { varray_storage_clause | [LOB { (lob_item
[,lob_item
...]) STORE AS ([TABLESPACEtablespace_name
] [{ENABLE | DISABLE} STORAGE IN ROW] [Storage_Clause
] [CHUNKinteger
] [PCTVERSIONinteger
] [CACHE | NOCACHE [LOGGING | NOLOGGING]]) | (lob_item
) STORE AS [(lob_segname
)] ...
Get Oracle in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.