| migrating SYS from DICT to LOCAL [message #166674] |
Fri, 07 April 2006 08:26  |
tridentadm
Messages: 142
Registered: March 2006
|
Senior Member |
|
|
i would like to know the implications if users faced when they have tried to make SYSTEM tablespace as 'LOCAL' as against 'DICTIONARY'.
We plan to do the same but are unaware of the advantages/disadvantages if any ??
|
|
|
|
|
|
|
|
| Re: migrating SYS from DICT to LOCAL [message #166766 is a reply to message #166742] |
Sat, 08 April 2006 04:18  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
Read about it.You will understand. Because , you have no other choice. LMT was introduced in 8i almost (almost 7 years ago). In present times, there is no reason for any oracle database to use DMT. Either you live worrying about space management or switch to LMT with uniform extent size and spend your time in a better way.
Anyhow DMT will be de-supported soon.
[Updated on: Sat, 08 April 2006 04:18] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
