DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: System Tablespace

  1. #1
    Join Date
    Jun 2000
    Location
    Maputo, Maputo-Mozambique
    Posts
    96
    I have my system tablespce with two datafiles.
    Is it recommended? If no, why?

    Regards
    Alexandre
    In god i trust

  2. #2
    Join Date
    Jan 2001
    Posts
    2,828

    Wink

    it all depends on what you store in the system tablespace not how many files are there in the system tablespace.tablespaces are like different trays in your refregirator some trays are ment for freezing some for keeping vegetables some for jams juices .say for example tarys meant for vegetables should always be stocked with vegetables and not say with coke bottles or anything else in the same way system table space should always conatin data dictonary information only as long as you adhere to this rule you are safe .

    hope this helps

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