Hands-On 05 (Managing Tablespaces and Datafiles using OEM)

As a DBA, you are responsible for managing Oracle tablespaces and datafiles. The following is a summary of your task:

1. Selecting a target database

2. Creating a tablespace

3. Creating a datafile

4. Changing the block size of a tablespace

5. Using the Locally Managed option

6. Adding an additional datafile to a tablespace

7. Using the automatically extend option

8. Obtaining a SQL statement syntax

9. Removing a tablespace

Hands-On 05 (Managing Tablespaces and Datafiles using OEM)

Description:

In this exercise you will learn how to create a tablespace, datafile,
add an additional datafile, and remove a tablespace using the Oracle 
Enterprise Management tool (OEM).

==Start.
Expand the Database item.

==
Expand the DBS4RMAN database.

==
Expand the Storage item.

==
Expand the Tablespaces item.

==
Highlight the "Tablespaces" item, right click and select "Create."

==
Enter a new tablespace name, such as DATA.

==
Change the datafile name, if it is needed.

== 
Change the File directory or the datafile size if it is needed.

==
Leave the tablespace status and type just as it is.

== 
On the Storage tab, use the Locally Managed option with an automatic
allocation.

== 
Notice that the block size can be changed.
Click "Create."

== 
The tablespace was created.

==
Expand the datafile of the DATA tablespace.

==
Notice that the datafile size is 10 megabytes.

==
Let's add one more datafile to the DATA tablespace.
Highlight Datafiles and create a new datafile.

==
Change the datafile name.

==
Change the datafile size to 10 megabytes.

==
In the Storage tab, select "Automatically extend datafile when is full"
with 1 Megabyte of extend and not to exceed more than 10 Megabytes.

==
Click on "Show SQL" and browse through the SQL statement.
Then click "Create."

==
The datafile was created. Notice that you now have two datafiles within
the DATA tablespace.

== 
Highlight "Tablespaces," and notice that the data tablespace size 
changed to 20 megabytes.

==
Highlight the Data tablespace, right click and remove the DATA tablespace.

==
Verify the remove request.

==
The data tablespace was removed.

==
For more information about the subject, you are encouraged
to read from a wide selection of available books.

Good Luck!