Use the DBMS_SPACE_ADMIN package to migrate the SYSTEM tablespace from dictionary-managed to locally managed. The following statement performs the migration:
SQL> EXECUTE DBMS_SPACE_ADMIN.TABLESPACE_MIGRATE_TO_LOCAL('SYSTEM');
Before performing the migration the following conditions must be met:
-
1.The database has a default temporary tablespace that is not SYSTEM.
-
2.There are no rollback segments in the dictionary-managed tablespace.
-
3.There is at least one online rollback segment in a locally managed tablespace, or if using automatic undo management, an undo tablespace is online.
-
4.All tablespaces other than the tablespace containing the undo space (that is, the tablespace containing the rollback segment or the undo tablespace) are in read-only mode.
-
5.The SYSAUX tablespace is offline.
-
6.The system is in restricted mode.
-
7.There is a cold backup of the database.
All of these conditions, except for the cold backup, are enforced by the TABLESPACE_MIGRATE_TO_LOCAL procedure.
Note:
After the SYSTEM tablespace is migrated to locally managed, any dictionary-managed tablespaces in the database cannot be made read/write. If you want to use the dictionary-managed tablespaces in read/write mode, then Oracle recommends that you first migrate these tablespaces to locally managed before migrating the SYSTEM tablespace.来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26844646/viewspace-1132170/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/26844646/viewspace-1132170/