Managing Tables   «Prev  Next»

Lesson 4Creating a table with Schema Manager
ObjectiveCreate 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.
  1. Deprecation of SNMP Support in Oracle Net Listener
  2. Changes to PL/SQL Procedures
  3. JOB_QUEUE_PROCESSES Parameter and Scheduling Jobs
  4. Deprecated XML DB Constructs
  5. Cursor_sharing=similar Deprecated in Oracle Database
  6. Planned Desupport of Change Data Capture
  7. Deprecation of the Data Mining Java API
  8. Initialization Parameters Deprecated in Oracle Database 11g Release 2 (11.2)
  9. Initialization Parameters Desupported in Oracle Database 11g Release 2 (11.2)
  10. Static Data Dictionary Views Deprecated in Oracle Database 11g Release 2 (11.2)
  11. Dynamic Performance Views Deprecated in Oracle Database 11g Release 2 (11.2)
  12. Deprecated Features in Oracle Database 11g Release 2 (11.2)
  13. 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 ships 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 NT as its basic platform. The interface is so simple that you can create a table without worrying about syntax at all.

Creating Table Schema Manager
Using the Schema Manager has two big advantages over entering your own SQL code:
  1. It is easier to use, since the graphical interface acts like a wizard to prompt you for the appropriate values.
  2. 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.