"Opportunities
multiply as they are seized." - Sun Tzu |
Read
first then play the video:
OEM-VIDEO -Managing
Database Objects
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 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.
|