December 2002
Intermediate to advanced
928 pages
85h 29m
English
CREATE/ALTER/DROP TABLE (Relational Syntax)
CREATE Syntax:
CREATE [GLOBAL] [TEMPORARY] TABLE [schema.]table_name(columndatatype[DEFAULTexpr] [Column_Constraint_Clause] [,columndatatype[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)] ...