To set table, tablespace, and schema options:

  1. Follow the steps in the Create Table wizard until the Name the Table window will open.

  2. Select the Schema Name from the drop down list. Your user login name is shown by default.

  3. Enter a table name in the Table Name field.

    Note: The table names should be unique for a single owner.

  4. Select a tablespace from the Tablespace menu.

    Note: By default, tables are placed in the default user tablespace (shown in the Tab lespace menu as DEFTABLESPACE).

  5. To import schema from another table:

    1. Click the Import Schema check box if you want the schema of the new table to be the same as the schema of another table in the database.

    2. Select the table to import from in the Table Namemenu.

  6. Click Next. The Add columns to the table window will open.


Related topic:

Setting Table, Tablespace, and Schema Options
Setting Column Options

To Set Column Options

To Start the Create Table Wizard