|
Managing Database Objects using OEM
Introduction
As a DBA, you
are responsible for managing database
objects. The following is a summary of your
task:
Covers:
Selecting a
target database
Creating a
table
Adding columns
and Datatypes
Changing
column attributes
Defining a
default storage parameter
Creating a
public synonym
Obtaining SQL
statement syntaxes
Hands-on
Expand the
Database item.
Expand the YOURDBNAME database.
Expand the Schema item.
Expand the Table item.
Highlight "Table", right click on it and
select "Create."
Enter a table name, such as JOBS.
Change its schema to ORACLE.
Change its tablespace to ORACLE_DATA.
Use it as a standard table.
Add a column with the VARCHAR2 datatype.
Add a second column with the NUMBER datatype.
Add a third column with the DATE datatype.
Make the COL2 column nullable.
In the Storage tab, enter the custom default
storage size. We assume from the pervious
Hands-On exercises, and at this level you
understand all the parameter on this screen.
Once you've finished, click "Show SQL" to
browse through the SQL statement.
Click "Create."
The table has been created.
Highlight "Synonym" and create a public
synonym for the JOBS table.
Enter the public synonym name, such as JOBS.
Make sure its schema is PUBLIC.
It is a local database.
The type is table.
The schema is ORACLE.
And, object is JOBS.
Click "Show SQL" to browse through the SQL
statement and then click "Create."
The synonym was created. |
