Re: Another Partitioning question

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Mon, 16 Sep 2002 20:17:50 GMT
Message-ID: <3D863C39.2263BF2D@exesolutions.com>

You limit by range of values (assuming you don't use the hash method)

For example:

CREATE TABLE purchases_pbr (
  clientno NUMBER(10),
  purchaseno NUMBER(10),

  itemname      VARCHAR2(30),
  amtpaid        NUMBER(10,2),

  purchasedate DATE)
PARTITION BY RANGE (purchasedate)
(partition OCT values less than (TO_DATE('01-NOV-2001', 'DD-MON-YYYY')) TABLESPACE data_sml,
partition NOV values less than (TO_DATE('01-DEC-2001', 'DD-MON-YYYY')) TABLESPACE data_sml,
partition DEC values less than (TO_DATE('01-JAN-2002', 'DD-MON-YYYY')) TABLESPACE data_sml);

Notice the "VALUES LESS THAN" phrase defining each partition.

Daniel Morgan

Konstantinos Agouros wrote:

> Hi,
>
> I took a look at Oracle's online docu and am a little confused. What I want to
> do is a partitioning where I have one partition per day (yes we generate so
> much data). The whole thing will run on 8.1.6 and .7.
>
> If I understood (8.1.5's) description correctly I can only limit by one value
> or am I wrong? Could someone give me an example of a create table-statement
> with a partition for a day? The Data is in full timestamp-format so I would
> need an upper and a lower bound I guess.
>
> Konstantin
> --
> Dipl-Inf. Konstantin Agouros aka Elwood Blues. Internet: elwood_at_agouros.de
> Otkerstr. 28, 81547 Muenchen, Germany. Tel +49 89 69370185
> ----------------------------------------------------------------------------
> "Captain, this ship will not survive the forming of the cosmos." B'Elana Torres
Received on Mon Sep 16 2002 - 15:17:50 CDT