Home » RDBMS Server » Server Administration » Dictionary Managed Tablespace to Locally Managed
Dictionary Managed Tablespace to Locally Managed [message #194416] Fri, 22 September 2006 01:28 Go to next message
M.Shakeel Azeem
Messages: 226
Registered: September 2006
Senior Member
Dear All
I know this query is very basic but i just want to confirm that
is there any harm to change any dictionary managed Tablespace to Locally managed
Although i have tested this thing but i just want to be assured

Re: Dictionary Managed Tablespace to Locally Managed [message #194488 is a reply to message #194416] Fri, 22 September 2006 06:43 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>is there any harm to change any dictionary managed Tablespace to Locally managed
I would say no. Infact from 9i you are supposed to used LMT.
>>Although i have tested this thing but i just want to be assured
How can we assure that whatever you did/planning to do will always endup without any trouble?
So play in safe mode. Take a backup before doing anything.
Do it in a test machine. Test before and after and compare.
Then do it in production.
Previous Topic: Renaming the Database
Next Topic: Session users
Goto Forum:
  


Current Time: Wed Mar 29 06:21:54 CDT 2017

Total time taken to generate the page: 0.21164 seconds