Re: Horizontal partitioning

In article <2ud6q9$inu_at_cleese.apana.org.au>, bmenglan_at_seldon.apanix.apana.org.au (Brett England) wrote:
>
> adam_at_pluto.logica.co.uk wrote:
> : 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.
>
> When you are creating your tablespaces, simply place different datafile onto
> separate disks.
>
> create tablespace index_data datafile
> '/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.

Granted that will give you a tablespace across multiple disk drives. however, It does not give you any indication how a table will be spread across those drives when placed in that tablespace. Some nice options here would be placement by key or blocks interleaved across all drives. Neither of these options are available in oracle as far as I know. The current implementation allows you work with large tables. It does not allow you to place tables across drives for performance reasons. If anyone from Oracle is watching, please consider this an offical beef of mine.

-Jeff Rule/Apple Computer e-mail:rule_at_apple.com Received on Tue Jun 28 1994 - 03:45:07 CEST