SYSTEM Tablespace & LMT
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: SYSTEM Tablespace & LMT

  1. #1
    Join Date
    Sep 2002
    Posts
    17
    We are creating a new 8i database and wanted to go with LMT for all our tablespaces. Can we have SYSTEM tablespace as LMT? If yes, is it better to go with LMT or DMT?

    Thanks.

  2. #2
    Join Date
    Sep 2002
    Posts
    411
    LMT is not available on 8i for SYSTEM tablespace, it's available on 9i

    Good luck

  3. #3
    Join Date
    Sep 2002
    Posts
    17
    Thanks for the quick reply. That confirms my research.

    I read somewhere that on 9i if you make SYSTEM LMT you will not be able to have any DMTs, which makes sense since Oracle is going away from DMTs in the database.

  4. #4
    Join Date
    Apr 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203
    axe, I'll confirm your last post. This is correct. Tried it myself.
    OCP 8i, 9i DBA
    Brisbane Australia

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