Re: Horizontal partitioning
Date: 23 Jun 1994 23:44:55 GMT
Message-ID: <2ud6q9$inu_at_cleese.apana.org.au>
adam_at_pluto.logica.co.uk wrote:
When you are creating your tablespaces, simply place different datafile onto
separate disks.
create tablespace index_data datafile
: Can anyone suggest how to partition a table across
: several discs in Oracle. It's simple in other RDBMSs
: but I can't see how to do it in Oracle.
'/disk1/index_data_0.dbf' size 100M,
'/disk2/index_data_1.dbf' size 100M,
'/disk3/index_data_2.dbf' size 100M
default storage (
pctincrease 0
);
--
._, . Brett England
_,' {_]\ email: bmenglan_at_apanix.apana.org.au
,' \
\ __ / "Just remember, wherever you go there you are"
"-' ^--' Buckaroo Banzai - across the fifth dimension.
Received on Fri Jun 24 1994 - 01:44:55 CEST