Partitioning on Timestamp with Time zone column in 10g
Date: Fri, 13 Mar 2009 10:57:20 -0700 (PDT)
Message-ID: <f2cbeafd-4ac2-457d-b25b-07d94980945c_at_w24g2000prd.googlegroups.com>
Hi
Is partitioning on Timestamp with Time zone data type possible in 10g? WHen I try the following it reports ORA-03001 unimplemented feature. The DW guide illustrates partitioning only on DATe columns and there is no specific mention of this 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 Received on Fri Mar 13 2009 - 12:57:20 CDT