> Oracle tables and indices within a single tablespace all live in
> one file (if you're using filesystem rather than raw I/O), so
> they also provide features which allow you to specify how big
> a chunk to allocate per extent (Oracle pre-allocates to avoid
> running out of disk space while you're running except in ways
> that you control, and in hopes of getting contiguous chunks of
> disk storage because they hope you're using previously empty
> disks used only for Oracle).
And with data and index in the same file, you can't split them across
spindles.
-- Bruce Momjian | http://www.op.net/~candle pgman@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026
