"Men have become the tools of their tools." - Henry
David Thoreau (1817-1862) |
Read
first then play the video:
OEM-VIDEO -Managing
Tablespaces and Datafiles
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.
|