Creating 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. If you did not create the connection with a user possessing the correct privileges, you will not be able to select Table from the New Gallery.

To create a table:

Select View | Connection Navigator .
Expand Database and select a database connection.
In the connection, expand a schema and right-click the Tables folder.
Choose New Table to open the Create Table wizard.
In the pages of the wizard enter parameters and select options to define the table.
Click Next.
On the Finish page, click Finish to create 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, available from the Oracle Technology Network (OTN) at http://www.oracle.com/pls/db92/db92.homepage.

Context Menu Shortcut:

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