Re: Horizontal partitioning

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 !

-- 
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
___