Hands-On 07 (Managing Database Objects using OEM)

As a DBA, you are responsible for managing database objects. The following is a summary of your task:

1. Selecting a target database

2. Creating a table

3. Adding columns and Datatypes

4. Changing column attributes

5. Defining a default storage parameter

6. Creating a public synonym

7. Obtaining SQL statement syntaxes

Hands-On 07 (Managing Database Objects using OEM)

Description:

In this exercise you will learn how to create a table, add columns,
change datatypes, and create public synonym using the Oracle 
Enterprise Management tool (OEM).

==Start.
Expand the Database item.

==
Expand the SCHOOL 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 ISLEF.

==
Change its tablespace to ISELF_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 ISLEF.

==
And, object is JOBS.

==
Click "Show SQL" to browse through the SQL statement and then click
"Create."

==
The synonym was created.

==

For more information about the subject, you are encouraged
to read from a wide selection of available books.

Good Luck!