Database Administration (MOSC)

MOSC Banner

table partition on TIMESTAMP(6) WITH TIME ZONE

Oracle enterprise version 19.15 

Want to create table portion on columt data type as TIMESTAMP(6) WITH TIME ZONE

Doc ID 1352487.1 shows the 12c is not OK to do. Does 19c good to do?

Sample as below. error as ORA-03001: unimplemented feature

CREATE TABLE CO_EXEC_TRACE_LG

(

 LOG_ENTRY_TIMESTAMP TIMESTAMP(6) WITH TIME ZONE NOT NULL,

 LOG_ENTRY_SEQUENCE  NUMBER(38,9)       NOT NULL,

 MESSAGE_INDEX    NUMBER(38,9)       NOT NULL,

 MESSAGE_LEVEL    VARCHAR2(20 BYTE),

 SERVER_ID      VARCHAR2(255 BYTE)

)

PARTITION BY RANGE (LOG_ENTRY_TIMESTAMP)

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