Name

CREATE/ALTER/DROP TABLE (Relational Syntax)

Synopsis

CREATE Syntax:

CREATE [GLOBAL] [TEMPORARY] TABLE [schema.]table_name  
(column  
                     datatype [DEFAULT expr] [Column_Constraint_Clause] 
  [,column  
                     datatype [DEFAULT expr] [Column_Constraint_Clause]...]
[Table_Constraint_Clause])
[ON COMMIT {DELETE | PRESERVE} ROWS]
[Physical_Attributes_Clause]
[TABLESPACE tablespace_name]   
[Storage_Clause]
[{LOGGING | NOLOGGING}]
[{COMPRESS | NOCOMPRESS}]
{ CLUSTER (column[,column ...])
| ORGANIZATION HEAP  
    [Physical_Attributes_Clause]
    [TABLESPACE tablespace_name]   
    [Storage_Clause]
    [{LOGGING | NOLOGGING}]
    [{COMPRESS | NOCOMPRESS}]
|  ORGANIZATION INDEX  
    [Physical_Attributes_Clause]
    [TABLESPACE tablespace_name]   
    [Storage_Clause]
    [{LOGGING | NOLOGGING}]
    { {MAPPING TABLE | NOMAPPING}
    | PCTTHRESHOLD integer
    | {COMPRESS integer | NOCOMPRESS}
    }
    [[INCLUDING colummn] 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
        ([TABLESPACE tablespace_name]
        [{ENABLE | DISABLE} STORAGE IN ROW]
        [Storage_Clause]
        [CHUNK integer]
        [PCTVERSION integer]
        [CACHE | NOCACHE [LOGGING | NOLOGGING]])
      | (lob_item) STORE AS [(lob_segname)] ...

Get Oracle in a Nutshell now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.