Re: Another Partitioning question

In <3D863C39.2263BF2D_at_exesolutions.com> Daniel Morgan <dmorgan_at_exesolutions.com> writes:

>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

Ahhhh so it is so intelligent to sort this in the right way. That would have been the only way that this might work.

Thanks,

Konstantin

>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

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