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.
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
