Re: partitioning tables (value = timestamp)

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

If you mean by date, then yes...Dates are significant to the second in Oracle.

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse