From: Geert De Paep <geert.depaep@pandora.be>
Subject: Re: partitioning tables (value = timestamp)
Date: 2000/08/08
Message-ID: <39907509.2A36CAFA@pandora.be>#1/1
Content-Transfer-Encoding: 8bit
References: <399036c3@news.lhsgroup.com>
X-Accept-Language: en
Content-Type: text/plain; charset=iso-8859-1
X-Trace: afrodite.telenet-ops.be 965768384 195.130.149.242 (Tue, 08 Aug 2000 22:59:44 MET DST)
Organization: Pandora - Met vlotte tred op Internet
MIME-Version: 1.0
Reply-To: geert.depaep@pandora.be
NNTP-Posting-Date: Tue, 08 Aug 2000 22:59:44 MET DST
Newsgroups: comp.databases.oracle.server


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