partitioning tables (value = timestamp)

From: Michael Schäfer <MSchaefer2_at_de.lhsgroup.com>
Date: 2000/08/08
Message-ID: <399036c3@news.lhsgroup.com>#1/1

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