Re: HELP !! ON LARGE TABLESPACES !!

Why can't the tablespace have multiple datafiles, each datafile on a separate disk?

Something like

CREATE TABLESPACE BIGTABSPACE
DEFAULT STORAGE ...

DATAFILE '/drv1/ORACLE/big1.dbf' size 1M,


                '/drv2/ORACLE/big2.dbf' size 1M,


                '/drv3/ORACLE/big3.dbf size 1M;

The above syntax or something like it should work. There is no rule that the
entire tablespace be on one disk, but remember that in the above case the largest
extent of any object is 1M. SO if you need a table with a initial extent of 1.5M,
forget it. Received on Tue Jul 18 1995 - 00:00:00 CEST