Home » RDBMS Server » Server Administration » LOCALLY MANAGED TABLESPACE
LOCALLY MANAGED TABLESPACE [message #51796] Thu, 13 June 2002 14:12 Go to next message
lily
Messages: 44
Registered: September 2000
Member
Hello,
I have three Dictionary managed Tabespace which I want to convert to Locally managed one. Anybody will help me how to do that from svrmgrl?

regards,lily.
Re: LOCALLY MANAGED TABLESPACE [message #51797 is a reply to message #51796] Thu, 13 June 2002 14:53 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
as per docs, Use the DBMS_SPACE_ADMIN package  
something like 

execute sys.DBMS_SPACE_ADMIN.TABLESPACE_MIGRATE_TO_LOCAL('SYSTEM');

This operation requires that:

1.	Migrate all other dictionary tablespaces to locally managed before
	migrating the system tablespace.
	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 with (9i), 
	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 complete cold backup of the database ( to be in the safer side)
6.	The system is in restricted mode
Re: LOCALLY MANAGED TABLESPACE [message #53447 is a reply to message #51796] Fri, 20 September 2002 01:06 Go to previous message
Thomas
Messages: 67
Registered: September 1999
Member
All I found is
execute dbms_space_admin.tablespace_migrate_to_local('TBLSPCNAME');

No idea how to do that without this package..

Thomas
Previous Topic: Re: Why the session can not be killed?
Next Topic: QUERY HELP
Goto Forum:
  


Current Time: Thu Sep 19 12:01:57 CDT 2024