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
 
Search WWH ::




Custom Search