Re: Advantage of Tablespace

Tablespaces are where the logical database - tables, indexes, etc. meets the physical database - where on the disks the data is actually residing. The administrative advantages include control of storage allocation, backup administration, and performance. I'm sure somebody can add to this, but lets look at some of these:

Storage allocation - you can limit where given users can store data, control how much storage they can take, set different defaults for initial and next extents.

Backup administration - you can create a logical structure of database files, use particular names and subdirectories for them so that it is easy to be very specific as to what gets backed up when.

Performance - you can distribute the workload among separate storage devices and controllers. For instance, tables and their indexes work best together if they are on separate devices. Received on Tue Feb 13 1996 - 10:44:10 CST