PL/SQL (MOSC)

MOSC Banner

TIMESTAMP WITH TIME ZONE in IOT

edited Mar 2, 2015 10:01AM in PL/SQL (MOSC) 8 commentsAnswered

Hello everybody,

IOTs provides good performance, just due to restriction is not possible to use TSTZ in the key.

Maybe somebody knows, is there a way, how to create a IOT with TIMESTAMP WITH TIME ZONE in the key? We are running 11g.

SQL>

CREATE TABLE iottest

     (tstz  TIMESTAMP WITH TIME ZONE PRIMARY KEY,

      val  NUMBER)

  ORGANIZATION INDEX

ORA-02329: Spalte vom Datentyp TIME/TIMESTAMP WITH TIME ZONE kann kein eindeutiger oder Primärschlüssel sein

CREATE TABLE iottest

     (tstz  TIMESTAMP WITH TIME ZONE,

      utc_time as (sys_extract_utc(x)) PRIMARY KEY,

      val  NUMBER)

  ORGANIZATION INDEX

ORA-54008: Spaltenausdruck wird bei einer index-organisierten Tabelle nicht unterstützt

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center