Re: Horizontal partitioning

From: Sandor Nieuwenhuijs <snieuwen_at_nl.oracle.com>
Date: Thu, 30 Jun 1994 15:22:21 GMT
Message-ID: <Cs7up9.LI5_at_nl.oracle.com>

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.
[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                                       ---

Received on Thu Jun 30 1994 - 17:22:21 CEST