Re: Multiple or Single tablespace

From: TurkBear <johng_at_mm.com>
Date: Wed, 10 Nov 1999 19:44:45 GMT
Message-ID: <3829c9f1.2328077@super.news-ituk.to>

In general,you should have nothing in the SYSTEM tablespace except what Oracle itself puts there - so you need at least 2 - In reality, it is best to have tablespaces that are tailored ( initial, max_extents, pct_increase, etc ) for the data that will be stored in them...I always set up a separate tablespace for indexes and one for rollback segments in addition to those set up to hold production and test data....

hth,
John Greco
Oracle DBA
MnDOT

Parker Sorenson <sparker_at_averstar.com> wrote:

>What are the benefits/pitfalls for using multiple or single tablespaces
>in a db system design?
>
>i.e. have 1 huge tablespace with several tables, OR have a few smaller
>tablespaces each with related tables...
>
>help is much thanked
>-p

-----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==---------- http://www.newsfeeds.com The Largest Usenet Servers in the World! ------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers ==----- Received on Wed Nov 10 1999 - 13:44:45 CST