Re: Oracle's use of tablespaces

From: Seth Grimes <grimes_at_access.digex.net>
Date: 31 Aug 1993 07:11:01 -0400
Message-ID: <grimes.746795328_at_access>


gerrit_at_vtm.be writes:

>Futhermore a tablespace allows you to manage your database more easyly :
>suppose you have three data disks : one for tables, one for indexes and one
>for temporary objects. Now you can create a tablespace for each type of
>dataobject on each disk and then you only have to specify for your indexes
>where to go (tables will go in the default table space for the user and
>temporary objects in the default temporary tablespace).

As I mentioned in an earlier post, you can do this with Ingres without tying up the space -- i.e., tell Ingres to grab the space on x device *if it needs to* and free up the space when its done. Sorry to belabor the point.

                        Seth Received on Tue Aug 31 1993 - 13:11:01 CEST

Original text of this message