Re: Oracle's use of tablespaces

>>>>> On 30 Aug 93 12:06:57 GMT, holowcza_at_andromeda.rutgers.edu (Richard D >>>>> Holowczak) said:  

> grimes_at_access.digex.net (Seth Grimes) writes:
 

>>Why does Oracle use tablespaces? On the balance, they seem unnecessarily >>complicated given the advantages they offer.  

> What would you do with the freed space if you had it ? You probably
> would not want to use it up since the next time you wish to run a
> query you'll need it back.

If I really need this space permanently allocated to the database, why not just go the next step and set up a (set of) raw partition(s) for the database?

> What happens when you guess wrong and the OS can't grab the space it
> needs ? What should the query do ? Abort ? In a real production
> environment, this kind of mistake can be very costly. I think Oracle
> is just taking the safest road. Make sure space is available no
> matter what else is going on.

If its a production environment, all the more reason to set up a raw partition...

--
====================================================================
David Masterson					Consilium, Inc.
(415) 691-6311					640 Clyde Ct.
davidm_at_consilium.com				Mtn. View, CA  94043
====================================================================
"Science is to computer science as hydrodynamics is to plumbing."
 - Stan Kelly-Bootle, _Computer Language_, Oct 90