|
Managing
Tablespaces and Datafiles using OEM
Introduction
As a DBA,
you are responsible for managing Oracle
tablespaces and datafiles. The following is
a summary of your task:
Covers:
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
Hands-on
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.
|
