SYSTEM ts - lmt or dmt?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: SYSTEM ts - lmt or dmt?

  1. #1
    Join Date
    Aug 2005
    Posts
    69

    SYSTEM ts - lmt or dmt?

    hi again,
    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?

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    in 9i LMT is the default - no reason to change it as far as I can see

  3. #3
    Join Date
    Jul 2002
    Posts
    335
    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.

    Bazza

  4. #4
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    Hi.

    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!

    Cheers

    Tim...
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: www.oracle-base.com
    My blog: www.oracle-base.com/blog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width