12 Managing Tablespaces

This chapter describes the various aspects of tablespace management, and contains the following topics:

• Guidelines for Managing Tablespaces

• Creating Tablespaces

• Specifying Nonstandard Block Sizes for Tablespaces

• Controlling the Writing of Redo Records

• Altering Tablespace Availability

• Using Read-Only Tablespaces

• Altering and Maintaining Tablespaces

• Renaming Tablespaces

• Dropping Tablespaces

• Managing the SYSAUX Tablespace

• Diagnosing and Repairing Locally Managed Tablespace Problems

• Migrating the SYSTEM Tablespace to a Locally Managed Tablespace

• Transporting Tablespaces Between Databases

• Tablespace Data Dictionary Views

  See Also:

  Chapter 15, "Using Oracle-Managed Files" for information about creating datafiles and tempfiles that are both created and managed by the Oracle Database server