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

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 Received on Fri Mar 13 2009 - 14:57:23 CDT