From: Connor McDonald <connor_mcdonald@yahoo.com>
Subject: Re: partitioning tables (value = timestamp)
Date: 2000/08/08
Message-ID: <398FFFF8.19BA@yahoo.com>#1/1
Content-Transfer-Encoding: 8bit
References: <399036c3@news.lhsgroup.com>
To: Michael Schäfer <MSchaefer2@de.lhsgroup.com>
Content-Type: text/plain; charset=iso-8859-1
X-Complaints-To: newsabuse@remarq.com
X-Trace: 965763705 LGTBT6QCL22D2D501C uk25.supernews.com
Organization: RemarQ http://www.remarQ.com
Mime-Version: 1.0
Reply-To: connor_mcdonald@yahoo.com
Newsgroups: comp.databases.oracle.server


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