SYSTEM ts - lmt or dmt?
in your opinions, if we are using lmt for 9i, should we also make the SYSTEM tablespace lmt - have heard from some people that you should leave it as dmt - is this true, and if so, why?
in 9i LMT is the default - no reason to change it as far as I can see
Have a quick look at metalink note 175434.1, there are a number of restictions of having a locally managed system tablespace, but these all relate to having or wanting other dictionary managed tablespaces.
If you currently have a DMT system tablespace due to upgrade from a previous version that didn't support LMT there's little point changing it, but if you are starting fresh then use LMT. I think it's pretty safe bet that DMT system tablespaces will not be available in the future, so you might as well get used to LMT now.
Regarding other tablespaces, it really depends on the usage. Given the choice I'd go LMT every time!
Click Here to Expand Forum to Full Width