| LMT and DMT [message #152988] |
Wed, 28 December 2005 05:30  |
venkatraghavan
Messages: 83
Registered: October 2005
Location: chennai
|
Member |
|
|
hi all,
i am going to use the locally managed tablespaces so regarding this i have certain queries i.e.
1: if i have LMT then at any time can i switch to dictionary managed tablespaces.(if yes ,so what is the command)
2: if i have dictionary managed tablespaces. then at any time can i switch to LMT(if yes, so what is the command).
|
|
|
|
| Re: LMT and DMT [message #152992 is a reply to message #152988] |
Wed, 28 December 2005 05:37  |
tarundua
Messages: 1080
Registered: June 2005
Location: India
|
Senior Member |
|
|
For both the questions the answer is NO,
if you are using Oracle version 9.2 onwards.
And its recommended by Oracle to use LMT.
|
|
|
|
| Re: LMT and DMT [message #153008 is a reply to message #152992] |
Wed, 28 December 2005 06:21 |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
>>if i have LMT then at any time can i switch to dictionary managed tablespaces.(if yes ,so what is the command)
Why?
As said by tarundba, it is not recomended.
>> if i have dictionary managed tablespaces. then at any time can i switch to LMT(if yes, so what is the command).
It is not a single command.THere is more to be known.
Look into dbms_space_admin.tablespace_migrate_to_local.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
