Topics: Managing Database Objects using
OEM
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:
-
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
|
More Resources by
Google: |
|
|
|
|
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!
|