How many tablespaces is enough?
Date: 24 Jun 92 19:06:23 GMT
Message-ID: <1992Jun24.190623.1_at_bbs.mdcbbs.com>
I have a database on a SCO/UNIX system that is as it was configured "out of the box". I still have the single SYSTEM tablespace that was created when I installed Oracle. My single tablespace is beginning to run out of space. I have been told you don't ever want your SYSTEM tablespace to fill up or your database will crash.
So I figure it is time to re-configure. I would like to just enlarge the size of my database and be done, but don't want to ever risk filling up the SYSETM tablespace, so I should probably split the stuff up. Now my problem. I am only dealing with a 30 megabyte database, I don't think it will grow to over 60 megabytes in the next year or so. What would be prudent for a tablespace setup? Is one for SYSTEM and one for USER enough?
+---------------------------------------------------------------------+ Barry A. Suskind Internet: suskind%edoras_at_mdcbbs.com MaBell: 703-560-5000x2348 UUCP: uunet!mdcbbs!edoras!suskind E-Systems / Melpar Division 7700 Arlington Blvd, Falls Church, VA 22046 JSNM Just Stark Naked MagicReceived on Wed Jun 24 1992 - 21:06:23 CEST