|Oracle9i Supplied PL/SQL Packages and Types Reference
Release 2 (9.2)
Part Number A96612-01
DBMS_SPACE_ADMIN package provides functionality for locally managed tablespaces.
Oracle9i Database Administrator's Guide for an example and description of using
This chapter discusses the following topics:
This package runs with
SYS privileges; therefore, any user who has privilege to execute the package can manipulate the bitmaps.
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.