Re: partitiong on timestamp with local timezone data type
From: Timo Raitalaakso <rafu_at_iki.fi>
Date: Fri, 24 May 2013 10:05:30 +0300
Message-ID: <519F113A.2090306_at_iki.fi>
Date: Fri, 24 May 2013 10:05:30 +0300
Message-ID: <519F113A.2090306_at_iki.fi>
If you consider using interval clause, timestamp with local timezone data type is not supported. You can create a date type virtual column calculated from the timestamp with local timezone column and use that virtual column for partitioning.
http://docs.oracle.com/cd/E11882_01/server.112/e26088/statements_7002.htm#i2146287
-- Timo Raitalaakso http://rafudb.blogspot.com 23.5.2013 20:45, Dba DBA kirjoitti:Received on Fri May 24 2013 - 09:05:30 CEST
> Oracle 11.2.0.3
> Production OS: Solaris (don't know the version)
> Timestamp with Local Timezone appears to meet this requirement and
> normalize it for me as long as I state the local timezone when I insert and
> set the dbtimezone parameter.
>
> 1. create table, partition by range on timestamp with local timezone by
> hour.
>
-- http://www.freelists.org/webpage/oracle-l