everythingOracle.bizhat.com

 

'Everything you wanted
to know about Oracle'

Training References Syntax Tell A Friend Contact Us

 

 

OEM

01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 16 17
<< Previous

Chapter # 07

Next >>


 

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 YOURDBNAME 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 ORACLE.

Change its tablespace to ORACLE_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 ORACLE.

And, object is JOBS.

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

The synonym was created.

     Reviews and Templates for FrontPage
     

Copyright � everythingOracle.bizhat.com 2006 All Rights Reserved