Name
CREATE/ALTER/DROP TABLE (Object Syntax)
Synopsis
CREATE Syntax:
CREATE [GLOBAL TEMPORARY] TABLE [schema
.]table_name
OF [schema.
]object_type
( { {column
|attribute
} [DEFAULTexpr
] { SCOPE IS [schema
.]scope_table_name
] | WITH ROWID | [CONSTRAINTconstraint_name
] REFERENCES [schema
.]object_table
[ON DELETE CASCADE] } | { SCOPE FOR ({column
|attribute
}) IS [schema
.]table_name
| REF ({column
|attribute
}) WITH ROWID | [CONSTRAINTconstraint_name
] FOREIGN KEY (column
) REFERENCES [schema
.]object_table
[ON DELETE CASCADE] [Constraint_State_Clause
] } ) [OBJECT ID {SYSTEM GENERATED | PRIMARY KEY}] [ON COMMIT {DELETE | PRESERVE} ROWS] [OIDINDEX [indexname
] ([physical_attributes_clause
] [TABLESPACEtablespace_name
])] [Physical_Attributes_Clause
] [TABLESPACE_NAMEtablespace_name
] [Storage_Clause
] [LOGGING | NOLOGGING] [CLUSTER (column
[,column
...]] [ { ORGANIZATION HEAP [Physical_Attributes_Clause
] [TABLESPACEtablespace_name
] [Storage_Clause]
[LOGGING | NOLOGGING] | ORGANIZATION INDEX [PCTTHRESHOLDinteger
] [COMPRESSinteger
| NOCOMPRESS] [Physical_Attributes_Clause
] [TABLESPACEtablespace_name
] [Storage_Clause
] [LOGGING | NOLOGGING] [[INCLUDINGcolumn
] OVERFLOW [Physical_Attributes_Clause
] [TABLESPACEtablespace_name
] [Storage_Clause
] [LOGGING | NOLOGGING]] } [LOB {(lob_item
[,lob_item
...]) STORE AS (LOB_Parameter_Clause) | (lob_item
) STORE AS [(lob_segname
)] [(LOB_Parameter_Clause)] ] [VARRAYvarray_item
STORE AS LOB [lob_segname
] [(LOB_Parameter_Clause)]] [NESTED TABLEnested_table ...
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.