SQL> help create table

 

 CREATE TABLE

 ------------

 

 Use this command to create a table, the basic structure to hold user

 data, specifying the following information:

 

          column definitions

          table organization definition

          column definitions using objects

          integrity constraints

          the table's tablespace

          storage characteristics

          an optional cluster

          data from an arbitrary query

          degree of parallelism used to create the table and the default

          degree of parallelism for queries on the table

          partitioning definitions

 

 Use CREATE TABLE to create an object table or a table that uses an

 object type for a column definition. An object table is a table

 explicitly defined to hold object instances of a particular type.

 

 You can also create an object type and then use it in a column when

 creating a relational table.

 

 Relational table definition

   CREATE TABLE [schema.] table

     [ ( { column datatype [DEFAULT expr] [WITH ROWID]

           [SCOPE IS [schema.] scope_table_name]

           [column_constraint] ...

         | table_constraint | REF (ref_column_name) WITH ROWID

         | SCOPE FOR (ref_column_name) IS [schema.]scope_table_name }

      [, { column datatype [DEFAULT expr] [WITH ROWID]

           [SCOPE IS [schema.] scope_table_name]

           [column_constraint] ...

         | table_constraint | REF (ref_column_name) WITH ROWID

         | SCOPE FOR (ref_column_name) IS

           [schema.]scope_table_name} ] ...) ]

     [ { [ ORGANIZATION {HEAP | INDEX}

           | PCTTHRESHOLD [INCLUDING column_name]

           [ OVERFLOW [physical_attributes_clause |

             TABLESPACE tablespace] ...]

         | physical_attributes_clause

         | TABLESPACE tablespace

           | LOB (lob_item [, lob_item ...] ) STORE AS

             [lob_segname]

           [ ( TABLESPACE tablespace

             | STORAGE storage_clause

             | CHUNK integer

             | PCTVERSION integer

             | CACHE

             | NOCACHE LOGGING | NOCACHE NOLOGGING

             | INDEX [lob_index_name]

             [ ( TABLESPACE tablespace

               |  STORAGE storage_clause

               |  INITRANS integer

               |  MAXTRANS integer ) ...] ) ]

           | NESTED TABLE nested_item STORE AS storage_table

           | {LOGGING | NOLOGGING} ] ...

         | CLUSTER cluster (column [, column] ...) } ]

       [ PARALLEL parallel_clause]

       [ PARTITION BY RANGE (column_list)

         ( PARTITION [partition_name] VALUES LESS THAN (value_list)

           [ physical_attributes_clause

           | TABLESPACE tablespace

           | {LOGGING | NOLOGGING} ] ) ...]

       [ ENABLE enable_clause | DISABLE disable_clause] ...

         [AS subquery]

         [CACHE | NOCACHE]

 

 physical_attributes_clause

   [ PCTFREE integer

   | PCTUSED integer

   | INITRANS integer

   | MAXTRANS integer

   | STORAGE storage_clause ]

 

 Object table definition

   CREATE TABLE [schema.]table OF [schema.]object_type

     [ ( [ column | attribute [DEFAULT expr] [WITH ROWID]

         [ SCOPE IS [schema.] scope_table_name]

         [column_constraint] ...]

       | table_constraint | REF (ref_column_name) WITH ROWID

       | SCOPE FOR (ref_column_name) IS [schema.]scope_table_name

       [, { column | attribute [DEFAULT expr] [WITH ROWID]

          [ SCOPE IS [schema.] scope_table_name]

          [column_constraint] ...

          | table_constraint | REF (ref_column_name) WITH ROWID

          | SCOPE FOR (ref_column_name) IS

            [schema.]scope_table_name} ] ...) ]

     [ OIDINDEX [index] [( physical_attributes_clause |

            TABLESPACE tablespace) ...]

       [ { [ physical_attributes_clause

           | TABLESPACE tablespace

           | LOB (lob_item [, lob_item ...]) STORE AS

             [ lob_segname]

             [ ( TABLESPACE tablespace

               | STORAGE storage_clause

               | CHUNK integer

               | PCTVERSION integer

               | CACHE

               | NOCACHE LOGGING | NOCACHE NOLOGGING

               | INDEX [lob_index_name]

                 [ ( TABLESPACE tablespace

                   |  STORAGE storage_clause

                   |  INITRANS integer

                   |  MAXTRANS integer ) ] ) ]

           | NESTED TABLE nested_item STORE AS storage_table

           | {LOGGING | NOLOGGING} ] ...

         | CLUSTER cluster (column [, column] ...) } ]

     [ PARALLEL parallel_clause]

     [ ENABLE enable_clause | DISABLE disable_clause] ...

     [ AS subquery]

     [ CACHE | NOCACHE]

 

 For detailed information on this command, see the Oracle8 Server SQL

 Reference.

 

 

 CREATE TABLESPACE

 -----------------

 

 Use this command to create a tablespace. A tablespace is an

 allocation of space in the database that can contain schema objects.

 

 CREATE TABLESPACE tablespace

 DATAFILE filespec

   [ AUTOEXTEND

     { OFF | ON

       [ NEXT integer [K | M] ]

       [ MAXSIZE

         { UNLIMITED | integer [K | M] } ] } ]

   [ LOGGING | NOLOGGING]

   [, filespec

     [ AUTOEXTEND

       { OFF | ON

         [ NEXT integer [K | M] ]

         [ MAXSIZE

           { UNLIMITED | integer [K | M] } ] } ] ]

   [LOGGING | NOLOGGING] ...

   [ MINIMUM EXTENT integer [K | M] ]

   [ DEFAULT STORAGE storage_clause

     | {ONLINE | OFFLINE}

     | {PERMANENT | TEMPORARY} ] ...

 

 For detailed information on this command, see the Oracle8 Server SQL

 Reference.