 |
|
Oracle Tips by Burleson |
OCP Instructors Guide for
Oracle DBA Certification
Chapter 5 - Oracle Database
Objects
Locally Managed System
Tablespaces
In Oracle9i Release 2, administrators are now able to create a
locally managed SYSTEM tablespace. The EXTENT MANAGEMENT LOCAL
clause can be used to create a locally managed SYSTEM tablespace
during database creation or administrators can use the stored
procedure dbms_space_admin.tablespace_migrate_to_local to
migrate existing dictionary managed tablespaces to locally managed.
Once you create or migrate to a locally managed SYSTEM tablespace,
you are unable to create any dictionary-managed tablespaces in the
database.
Care must be taken when using the
aforementioned package to migrate SYSTEM tablespaces from dictionary
managed to locally managed. It is a requirement that all
tablespaces (except those containing UNDO segments) be in READ ONLY
mode for the migration process to successfully execute. If Oracle
finds any tablespaces in READ WRITE mode, the error message states
that the tablespaces must be placed in READ ONLY mode.
The problem is that if the administrator places
any dictionary-managed tablespaces in READ ONLY mode, they will be
unable to place them in READ WRITE mode after the SYSTEM tablespace
is converted to locally managed. Administrators desiring to migrate
their SYSTEM tablespaces to locally managed must migrate all READ
WRITE dictionary managed tablespaces to locally managed tablespaces
BEFORE MIGRATING THE SYSTEM TABLESPACE.
The above text is
an excerpt from:
OCP Instructors Guide for Oracle DBA Certification
A Study Guide to Advanced Oracle Certified Professional Database
Administration Techniques
ISBN 0-9744355-3-8
by Christopher T. Foot
http://www.rampant-books.com/book_2003_2_OCP_print.htm
|
Download your Oracle scripts now:
www.oracle-script.com
The
definitive Oracle Script collection for every Oracle professional DBA
|
|
