Newsgroups: comp.databases.oracle
From: snieuwen@nl.oracle.com (Sandor Nieuwenhuijs)
Subject: Re: Horizontal partitioning
Message-ID: <Cs7up9.LI5@nl.oracle.com>
Sender: news@nl.oracle.com
Nntp-Posting-Host: nlsun1
Organization: Oracle Europe
X-Newsreader: TIN [version 1.2 PL1]
References: <CrJvBM.C05@carmen.logica.co.uk> <2ud6q9$inu@cleese.apana.org.au> <rule-270694184249@17.1.7.156>
Date: Thu, 30 Jun 1994 15:22:21 GMT
Lines: 28


Jeff Rule (rule@apple.com) wrote:
: In article <2ud6q9$inu@cleese.apana.org.au>,
: bmenglan@seldon.apanix.apana.org.au (Brett England) wrote:
: > 
: > adam@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.
[stuff deleted]

In Oracle7 there is a new command:

ALTER TABLE <schema>.<table>
ALLOCATE EXTENT
({ SIZE ... } {DATAFILE ...} {INSTANCE ...})
 ** for the exact syntax: Oracle7 Server SQL Language Reference manual,
 ** page 4-71 - 4-73

With this command you can specify to reserve a certain amount
of space in specific datafiles. With this command and some smart
calculations you can even store certain key values in certain files
(and for this reason on seperate devices), provided the table does not
change dramatically afterwards.

Sandor Nieuwenhuijs
Oracle Netherlands
--- These opinions (if any) are just mine. I do not represent Oracle  ---
--- Corporation in this Posting                                       ---