Managing Tables   «Prev 

Column Datatypes

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

  1. You have already selected the Schema Manager from the Oracle Enterprise Manager program group. Click Oracle Enterprise Manager.
  2. Log in as user SCOTT with password TIGER, and then click the OK button.
  3. 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.
  4. To create a new table, right-click the SCOTT schema name.
  5. Select the Create menu choice.
  6. 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.
  7. Click OK.
  8. 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.
  9. Click the drop-down arrow for the Datatype of the column, VARCHAR2 (the top one).
  10. Assign a datatype of NUMBER for column1.
  11. You have defined a simple, one column table. Click the Create button at the bottom of the form to finish the job.
  12. Click the A_TABLE table entry at top right to see the results of your work.
  13. You will be using this table in a later module. This is the end of the simulation. Click Exit.