Re: partitiong on timestamp with local timezone data type

  • From: Timo Raitalaakso <rafu@xxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Fri, 24 May 2013 10:05:30 +0300

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:
> 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


Other related posts: