Lesson 4	Creating a table with Schema Manager
Objective	Create a table using the Schema Manager.

Creating table with Schema Manager in Oracle

Changes for Earlier Releases of Oracle Database

There are important changes in behavior between Oracle Database 10g Release 2 (10.2), Oracle Database 11g Release 1 (11.1), and Oracle Database 11g Release 2 (11.2). Behavior changes typically require a database administrator (DBA) to make informed decisions to minimize the risks that may be introduced by the changes after upgrading Oracle Database.
Behavior Changes in Oracle Database 11g Release 2 (11.2) Oracle Database 11g Release 2 (11.2) introduces new features and changes that affect compatibility and interoperability. The following changes may affect the upgrade process.

Deprecation of SNMP Support in Oracle Net Listener
Changes to PL/SQL Procedures
JOB_QUEUE_PROCESSES Parameter and Scheduling Jobs
Deprecated XML DB Constructs
Cursor_sharing=similar Deprecated in Oracle Database
Planned Desupport of Change Data Capture
Deprecation of the Data Mining Java API
Initialization Parameters Deprecated in Oracle Database 11g Release 2 (11.2)
Initialization Parameters Desupported in Oracle Database 11g Release 2 (11.2)
Static Data Dictionary Views Deprecated in Oracle Database 11g Release 2 (11.2)
Dynamic Performance Views Deprecated in Oracle Database 11g Release 2 (11.2)
Deprecated Features in Oracle Database 11g Release 2 (11.2)
Changes to LOG_ARCHIVE_DEST_n Parameters

Oracle DBA

Creating table with Schema Manager

You now know the SQL syntax necessary to create a table. Oracle shipped with a graphical management tool with Oracle 8 and later called the Oracle Enterprise Manager (OEM), enabling you to handle many database management tasks without having to use the character-based command interface of SQL*Plus. You can use the Schema Manager, which is one of the modules of OEM, to create a table without typing in the SQL syntax. With Schema Manager, all you do is enter the name of the table and the names and datatypes of the columns in the table.
To understand how to use the Schema Manager, step through the following simulation, which demonstrates the steps of creating a small table. The simulation uses OEM on Windows Server as its basic platform. The interface is so simple that you can create a table without worrying about syntax at all.
Using the Schema Manager has two big advantages over entering your own SQL code:

It is easier to use, since the graphical interface acts like a wizard to prompt you for the appropriate values.
Because the Schema Manager always creates valid SQL syntax from the values you enter, you avoid syntax mistakes because of misspelled or missing keywords.

The Schema Manager does not prevent all errors and you can still enter invalid values that result in an invalid SQL statement, but it is still a helpful addition to your tool chest. The next lesson shows how to ask Oracle for information about the tables in the database.

Deprecation of Oracle Enterprise Manager Database Control

Oracle Enterprise Manager Database Control is deprecated in Oracle Database 11g Release 2 (11.2), and will be desupported in the next major release of Oracle Database. Oracle will fully support Oracle Enterprise Manager Database Control for the life of Oracle Database 11g Release 2 (11.2), including for all patch sets, and through the end of Extended Support.

Creating a table with Schema Manager

You have already selected the Schema Manager from the Oracle Enterprise Manager program group. Click Oracle Enterprise Manager.
Log in as user SCOTT with password TIGER, and then click the OK button.
The Tables listing contains all the schemas to which user SCOTT has access. Click the plus sign to the left of the SCOTT schema to show the tables in that schema.
To create a new table, right-click the SCOTT schema name.
Select the Create menu choice.
You will be prompted as to whether you want to use the Table Wizard or want to create a table manually. Because the Table Wizard will lead you through many different pages, asking about options that are not of interest to you at this time, select the Create Table Manually radio button.
Click OK.
The Create Table dialog lets you easily define the table and the columns it contains by simply filling in the blanks. You start by adding a name for this table, test_table in the Name field at the top of the form. Next, in the first row of the Define columns table, type column1 as the Name of the column. Then click anywhere in the simulation to continue.
Click the drop-down arrow for the Datatype of the column, VARCHAR2 (the top one).
Assign a datatype of NUMBER for column1.
You have defined a simple, one column table. Click the Create button at the bottom of the form to finish the job.
Click the A_TABLE table entry at top right to see the results of your work.
You will be using this table in a later module. This is the end of the simulation. Click Exit.