Re: Partitioning on Timestamp with Time zone column in 10g

From: GTSP Inc <suresh364_at_gmail.com>
Date: Fri, 13 Mar 2009 12:59:42 -0700 (PDT)
Message-ID: <ec49a89e-7120-473b-b58f-695ed6f061e4_at_y38g2000prg.googlegroups.com>

On Mar 13, 12:57 pm, ddf <orat..._at_msn.com> wrote:
> Comments embedded.
>
> On Mar 13, 12:57 pm, GTSP Inc <suresh..._at_gmail.com> wrote:
>
> > Hi
>
> > Is partitioning on Timestamp with Time zone data type possible in 10g?
> > WHen I try the following it reports ORA-03001 unimplemented feature.
>
> Then the answer is obviously 'No'.
>
> > The DW guide  illustrates partitioning only on DATe columns and there
> > is no specific mention of this data type.
>
> Then you can't partition on that data type.
>
>
>
> > create table testtbl
> > (id number,
> >  tm_date timestamp with time zone
> > )
> > partition by RANGE (tm_date)
> > (
> > PARTITION DEC_2008 VALUES LESS THAN (TO_TIMESTAMP_TZ('2009-01-01
> > 11:00:00 -8:00','YYYY-MM-DD HH:MI:SS TZH:TZM'))
> > )
> > NOCOMPRESS
> > NOCACHE
> > NOPARALLEL
> > MONITORING;
>
> > But it works for TIMESTAMP WITH LOCAL TIMESTAMP data type column
>
> > create table testtbl
> > (id number,
> >  tm_date timestamp with local time zone
> > )
> > partition by RANGE (tm_date)
> > (
> > PARTITION DEC_2008 VALUES LESS THAN (TIMESTAMP'2009-01-01 00:00:00
> > +0:00')
> > )
> > NOCOMPRESS
> > NOCACHE
> > NOPARALLEL
> > MONITORING;
>
> > Thanks for your inputs,
>
> > Suresh
>
> David Fitzjarrell

Thanks for the response. I was wondering if I missed something. I will have to find other candidates for partitioning.

Thanks

Suresh Received on Fri Mar 13 2009 - 14:59:42 CDT