Re: Horizontal partitioning

In article <2u3ft4$idb_at_netserver.univ-lille1.fr>, noel_at_omega.univ-lille1.fr (Yves Noel) writes:
>
>In article <CrJvBM.C05_at_carmen.logica.co.uk>, adam_at_pluto.logica.co.uk writes:
>|>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.
>|>
>Well, with ORACLE it's simple too :
>
>CREATE TABLESPACE TS DATAFILE
> 'file1_on_disk1' size ...M,
> 'file2_on_disk2' size ...M,
> 'file3_on_disk3' size ...M;
>
>CREATE TABLE T (...) TABLESPACE TS
>STORAGE (INITIAL ...M NEXT ...M MINEXTENTS 3 PCTINCREASE 0);
>
>Hope this help !

Yes, but I want to be able to control which rows of the table go into which partition based around a key value.
>--
>Yves NOEL ______________________________________________ C.I.T.I. (batiment M4)
>Database Administrator ________________ Universite des Sciences et Technologies
>Email: Yves.Noel_at_univ-lille1.fr ________ 59655 Villeneuve d'Ascq Cedex - FRANCE
>Voice: (33) 20.33.70.74 _________________________________ Fax: (33) 20.43.66.25
>
>I use ORACLE v6.0.36 on DEC RISC ULTRIX v4.3
>___
Received on Mon Jun 20 1994 - 15:35:28 CEST