CREATE/ALTER/DROP TABLE 
						
						
						CREATE [GLOBAL] [TEMPORARY] TABLE [schema.]tablename  
  (column
						datatype [DEFAULT expression] [Column_Contraint] 
   [,column
						datatype [DEFAULT expression] [Column_Contraint]]...)
 [Table_Constraint_Clause]
 [Physical_Attributes_Clause]
 [TABLESPACE tablespace]   
 [STORAGE Storage_Clause]
 [LOGGING | NOLOGGING]
 [CLUSTER (column[,column ...])]
 [{ORGANIZATION HEAP  
    [Physical_Attributes_Clause]
    [TABLESPACE tablespace]   
    [STORAGE Storage_Clause]
    [LOGGING | NOLOGGING] |
   ORGANIZATION INDEX  
    [PCTTHRESHOLD integer]
    [COMPRESS integer | NOCOMPRESS]
    [Physical_Attributes_Clause]
    [TABLESPACE tablespace]   
    [STORAGE Storage_Clause]
    [LOGGING | NOLOGGING]
    [[INCLUDING column] OVERFLOW
      [Physical_Attributes_Clause]
      [TABLESPACE tablespace]   
      [STORAGE Storage_Clause]
      [LOGGING | NOLOGGING]
  }]
 [LOB {(lob_item[,lob_item ...]) STORE AS
        ([TABLESPACE tablespace]
         [{ENABLE | DISABLE} STORAGE IN ROW]
         [STORAGE Storage_Clause]
         [CHUNK integer]
         [PCTVERSION integer]
         [CACHE | NOCACHE [LOGGING | NOLOGGING]]
        )
       ) |
       (lob_item) STORE AS [(lob_segname)]
        [([TABLESPACE tablespace]
          [{ENABLE | DISABLE} STORAGE IN ROW]
          [STORAGE Storage_Clause]
          [CHUNK integer]
          [PCTVERSION integer]
          [CACHE | NOCACHE [LOGGING | NOLOGGING]]
       )]
      }
[Partition_Clause]
[ENABLE | DISABLE ROW MOVEMENT]
[CACHE | NOCACHE]
[MONITORING | NOMONITORING]
[PARALLEL integer | NOPARALLEL]
[ENABLE | DISABLE [VALIDATE | NOVALIDATE]]
   {UNIQUE (column[, column ...] | PRIMARY KEY | CONSTRAINT constraint_name}
   [USING INDEX   
   [TABLESPACE tablespace] 
   [Physical_Attributes_Clause ...

Get Oracle SQL: the Essential Reference 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.

Start your free trial