Creating Online Tables

The user name you use to create the connection must have adequate privilege to create a table, either by having been granted CREATE TABLE privilege or having been granted a role such as administrator that contains that privilege.

To create a table:

Select View Connection Navigator.
Expand Database and select a database connection.
Right-click the connection or anything in it, and choose New to open the New Gallery.
In the New Gallery, if the Database Tier is not visible in Categories, in Filter By, choose All Technologies.
In Categories, expand Database Tier and select Database Objects.
From Database Objects, select Table and click OK to open the Create Table wizard.
In the pages of the wizard enter parameters and select options to define the table.

For information about how to fill in values for the the wizard parameters and options, click Help in the dialog, or see the CREATE TABLE section of the Oracle Database SQL Reference at http://www.oracle.com/technology/documentation/database10g.html.

Context Menu Shortcut:

From the Connections Navigator, select the Tables node in a schema and right-click it, then select New Table .