Re: Horizontal partitioning

Jeff Rule (rule_at_apple.com) wrote:
: 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

Hi.....

The only way to achieve 'perfect' partition of tables/indexes across various disks is to make use of OS disk stripping.

If you need more info please email me..

Amit

--
                                  _____________
    Amit Gupta                        churchill        Tel: +44 81 313 5688
    Sr. Database Administrator    =============        Fax: +44 81 313 5699
    Churchill Management
    15-17 London Rd, Bromley BR1 1DE, UK.    Email: amit_at_churchill.co.uk