iSelfSchooling.com  Since 1999     References  |  Search more  | Oracle Syntax  | Free Online Oracle Problem Solver

    .Home      .Subscribe     .Login      .Start Learning      .Certification      .Cancel      .Password Reminder      .Password Change     .Sign out

 

. Online Accounting        .Copyright & User Agreement   |
    .Vision      .Biography     .Acknowledgement

.Contact Us      .Comments/Suggestions       .Email2aFriend    |

 

Online Oracle Training for beginners and advanced - The most comprehensive Oracle tutorial

The authors do not guarantee or take any responsibility for the accuracy, or completeness of the information.

DBAs - OEM

 

Lesson 01 | Lesson 02 | Lesson 03 | Lesson 04 | Lesson 05 | Lesson 06 | Lesson 07 | Lesson 08 | Lesson 09 | Lesson 10 | Lesson 11 | Lesson 12 | Lesson 13 | Lesson 14 | Lesson 15 | Lesson 16 |

 

Lesson 07

"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.