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)