Topics: Managing Tablespaces and Datafiles using
OEM
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:
-
Selecting a target database
-
Creating a tablespace
-
Creating a datafile
-
Changing the block size of a
tablespace
-
Using the Locally Managed option
-
Adding an additional datafile to
a tablespace
-
Using the automatically extend
option
-
Obtaining a SQL statement syntax
-
Removing a tablespace
|
More Resources by
Google: |
|
|
|
|
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!
|