multiply as they are seized." - Sun Tzu
first then play the video:
Managing Database Objects
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
Changing column attributes
Defining a default storage
Creating a public synonym
Obtaining SQL statement
Expand the Database item.
Expand the SCHOOL database.
Expand the Schema item.
Expand the Table item.
Highlight "Table", right click on it and select
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
The table has been created.
Highlight "Synonym" and create a public synonym for the JOBS
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.