From: "Michael Schäfer" <MSchaefer2@de.lhsgroup.com>
Subject: partitioning tables (value = timestamp)
Date: 2000/08/08
Message-ID: <399036c3@news.lhsgroup.com>#1/1
X-Trace: 8 Aug 2000 12:35:15 -0500, 208.140.123.147
Organization: LHS Group
X-MSMail-Priority: Normal
X-Priority: 3
Newsgroups: comp.databases.oracle.server
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300


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