Re: HELP !! ON LARGE TABLESPACES !!
From: Greg Tupper <gtupper_at_monkfish.nosc.mil>
Date: 1995/07/19
Message-ID: <3uhmi5$jrv_at_pandora.sdsu.edu>#1/1
Date: 1995/07/19
Message-ID: <3uhmi5$jrv_at_pandora.sdsu.edu>#1/1
I think you only need to specify the datafiles that the tablespace is made up of.
Create tablespace large_ts datafile '/disk1/datafile.dbf' size 1000M,
'/disk2/datafile2.dbf' size 1000M,
'/disk3/datafile3.dbf' size 1000M
/
Now, I do not know if this will automatically cause the tables created in the tablespaces to be striped across all three disks. Perhaps someone else will have this information.
Greg Tupper
SAIC Comsystem
gtupper_at_nosc.mil
Received on Wed Jul 19 1995 - 00:00:00 CEST