Re: partitioning tables (value = timestamp)

From: Geert De Paep <geert.depaep_at_pandora.be>
Date: 2000/08/08
Message-ID: <39907509.2A36CAFA@pandora.be>#1/1

Make sure to use the to_date function:

values less than ( to_date('08-aug-2000','dd-mon-yyyy') )

Geert De Paep
DBA stuff on http://www.dba-village.com

"Michael Schäfer" wrote:
>
> Hi,
>
> is there a possibility to partition a table by the value of timestamps ??
>
> CREATE TABLE BLABLA ...
> PARTITION BY RANGE ( ENTRY_DATE_TIMESTAMP )
> ( PARTITION PART_1 VALUES LESS THAN ( Here I need a timestamp like
> >08/15/2000 00:00< )
> TABLESPACE "DATA"
> PCTFREE 15 PCTUSED 40
> INITRANS 5 MAXTRANS 255
> STORAGE ( INITIAL 50 M NEXT 50 M PCTINCREASE 0
> FREELISTS 10 FREELIST GROUPS 2 ),
> PARTITION PART_2 VALUES LESS THAN ( 09/01/2000 00:00 )
> TABLESPACE "DATA"
> PCTFREE 15 PCTUSED 40
> INITRANS 5 MAXTRANS 255
> STORAGE ( INITIAL 50 M NEXT 50 M PCTINCREASE 0
> FREELISTS 10 FREELIST GROUPS 2 ))
> PARALLEL ( DEGREE 10 INSTANCES 2 )
>
> Thanks,
>
> Mike
Received on Tue Aug 08 2000 - 00:00:00 CDT