| Making SYSTEM tbs locally managed [message #124540] |
Mon, 20 June 2005 00:42  |
PompeytilIDie
Messages: 9
Registered: March 2005
Location: Western Australia
|
Junior Member |
|
|
The dba before me made the system tbs Dict managed and I of course want to rectify this. I stumbled upon a 'handy' pl/sql proc to do this:
execute sys.dbms_space_admin.tablespace_migrate_to_local('SYSTEM');
Of course this should do but it belly aches that DB has to be in restrict mode. When I do it complains it should be in Read Only mode? I do this ALTER DATABASE OPEN READ ONLY; from a mount mode, try running the proc but complains again should be in RESTRICTED mode.
I dedue from this I need to do to get the DB in a restricted access read only mode? Any other suggestion extremely grateful.
|
|
|
|
| Re: Making SYSTEM tbs locally managed [message #124578 is a reply to message #124540] |
Mon, 20 June 2005 06:19  |
salmansh
Messages: 14
Registered: June 2005
Location: Al-Khobar
|
Junior Member |
|
|
Hi,
This is what I found from the docs, hth.
Migrating the SYSTEM Tablespace to a Locally Managed Tablespace
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 dictionary-managed tablespaces.
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 There is a cold backup of the database.
6 The system is in restricted mode.
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 be able to use the
dictionary-managed tablespaces in READ-WRITE mode, Oracle
recommends that you first migrate these tablespaces to locally
managed before migrating the SYSTEM tablespace.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
