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.