68
DBMS_SPACE_ADMIN

The DBMS_SPACE_ADMIN package provides functionality for locally managed tablespaces.

This chapter discusses the following topics:

• Security
• SYSTEM Tablespace Migration: Conditions
• Constants for DBMS_SPACE_ADMIN Constants
• Summary of DBMS_SPACE_ADMIN Subprograms

Security

This package runs with SYS privileges; therefore, any user who has privilege to execute the package can manipulate the bitmaps.

SYSTEM Tablespace Migration: Conditions

Before you migrate the SYSTEM tablespace, you should migrate any dictionary-managed tablespaces that you may want to use in read/write mode to locally managed. After the SYSTEM tablespace is migrated, you cannot change dictionary-managed tablespaces to read/write.

Before migrating the SYSTEM tablespace, the following conditions must be met. These conditions are enforced by the TABLESPACE_MIGRATE_TO_LOCAL procedure, except for the cold backup.

• The database must have a default temporary tablespace that is not SYSTEM.
• Dictionary-managed tablespaces cannot have any rollback segments.
• A locally managed tablespace must have at least one online rollback segment. If you are using automatic undo management, an undo tablespace must be online.
• All tablespaces--except the tablespace containing the rollback segment or the undo tablespace--must be read-only.
• You must have a cold backup of the database.
• The system must be in restricted mode.