Database Reference
In-Depth Information
11.5 Tablespace Management
Once the tablespace has been created and populated with database objects, it will need
to be managed. This is normally done via the
Alter-Tablespace
command. Through
this command, you can effect structural as well as status changes to the tablespace. As
with the
Create-Tablespace
command, a full discussion of is beyond the scope of this
course. However, in the interest of credibility, its syntax, as well as an example is provided
in Figure
11-7
. Of course, you can also delete a tablespace via the
Drop-Tablespace
statement. Figure
11-8
provides the syntax along with an example. Finally, through a
component called Oracle Enterprise Manager (OEM), you can manage tablespaces (and
most other database objects) in a GUI environment.
Figure 11-7.
Syntax for Alter-Tablespace Statement
Figure 11-8.
Syntax for Drop-Tablespace Statement