Query:
select auditmessa0_.id as id1_0_,
auditmessa0_.additions as additions2_0_,
auditmessa0_.emulator_domain as emulator_domain3_0_,
auditmessa0_.emulator_user_id as emulator_user_id4_0_,
auditmessa0_.emulator_username as emulator_username5_0_,
auditmessa0_.error as error6_0_,
auditmessa0_.event_action as event_action7_0_,
auditmessa0_.event_category as event_category8_0_,
auditmessa0_.event_desc as event_desc9_0_,
auditmessa0_.metadata as metadata10_0_,
auditmessa0_.ip_address as ip_address11_0_,
auditmessa0_.legal_entity_id as legal_entity_id12_0_,
auditmessa0_.message_set_id as message_set_id13_0_,
auditmessa0_.object_type as object_type14_0_,
auditmessa0_.schema_version as schema_version15_0_,
auditmessa0_.sa_id as sa_id16_0_,
auditmessa0_.status as status17_0_,
auditmessa0_.temp_legacy_id as temp_legacy_id18_0_,
auditmessa0_.event_time as event_time19_0_,
auditmessa0_.user_agent as user_agent20_0_,
auditmessa0_.actor_user_id as actor_user_id21_0_,
auditmessa0_.actor_username as actor_username22_0_
from audit_message auditmessa0_
where auditmessa0_.event_time >= to_timestamp('Jan 01 09:40:08 2022', 'Mon DD HH:MI:SS YYYY')
and auditmessa0_.event_time < to_timestamp('Oct 23 09:40:09 2022', 'Mon DD HH:MI:SS YYYY')
and lower(auditmessa0_.sa_id) = '8a00861780ce9dba0180fe6e971c058c'
order by auditmessa0_.event_time desc
--TABLE AUDIT_MESSAGETEST?
Audit_messagetest
--------------------------------------------------------
-- File created - Wednesday-October-26-2022
--------------------------------------------------------
--------------------------------------------------------
-- DDL for Table AUDIT_MESSAGETEST
--------------------------------------------------------
CREATE TABLE "AUDIT_PERSISTENCE"."AUDIT_MESSAGETEST"
( "ID" NUMBER(38,0),
"STATUS" VARCHAR2(11 BYTE) DEFAULT 'Unknown',
"EVENT_TIME" TIMESTAMP (6),
"ACTOR_USER_ID" VARCHAR2(36 BYTE),
"ACTOR_USERNAME" NVARCHAR2(64),
"EVENT_CATEGORY" VARCHAR2(35 BYTE),
"OBJECT_TYPE" VARCHAR2(35 BYTE),
"EVENT_ACTION" VARCHAR2(35 BYTE),
"EVENT_DESC" NVARCHAR2(511),
"MESSAGE_SET_ID" VARCHAR2(36 BYTE),
"LEGAL_ENTITY_ID" VARCHAR2(36 BYTE),
"SA_ID" VARCHAR2(36 BYTE),
"IP_ADDRESS" VARCHAR2(45 BYTE),
"USER_AGENT" VARCHAR2(255 BYTE),
"SCHEMA_VERSION" VARCHAR2(36 BYTE),
"ERROR" VARCHAR2(255 BYTE),
"METADATA" CLOB,
"ADDITIONS" CLOB,
"TEMP_LEGACY_ID" VARCHAR2(36 BYTE),
"EMULATOR_USER_ID" VARCHAR2(36 BYTE),
"EMULATOR_USERNAME" NVARCHAR2(64),
"EMULATOR_DOMAIN" NVARCHAR2(127)
) PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255
COMPRESS BASIC
STORAGE(
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "TBS_AUDIT_MESS_DEC20"
LOB ("METADATA") STORE AS SECUREFILE (
ENABLE STORAGE IN ROW CHUNK 8192
NOCACHE LOGGING NOCOMPRESS KEEP_DUPLICATES
STORAGE(
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
LOB ("ADDITIONS") STORE AS SECUREFILE (
ENABLE STORAGE IN ROW CHUNK 8192
NOCACHE LOGGING NOCOMPRESS KEEP_DUPLICATES
STORAGE(
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
PARTITION BY RANGE ("EVENT_TIME") INTERVAL (NUMTOYMINTERVAL(1,'MONTH'))
SUBPARTITION BY HASH ("ACTOR_USER_ID")
SUBPARTITIONS 32
(PARTITION "P0" VALUES LESS THAN (TIMESTAMP' 2006-01-01 00:00:00')
PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255
STORAGE(
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "BACKBASEDATA"
COMPRESS BASIC
LOB ("METADATA") STORE AS SECUREFILE (
ENABLE STORAGE IN ROW CHUNK 8192
NOCACHE LOGGING NOCOMPRESS KEEP_DUPLICATES
STORAGE(
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
LOB ("ADDITIONS") STORE AS SECUREFILE (
ENABLE STORAGE IN ROW CHUNK 8192
NOCACHE LOGGING NOCOMPRESS KEEP_DUPLICATES
STORAGE(
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT))
( SUBPARTITION "SYS_SUBP13527" SEGMENT CREATION DEFERRED
LOB ("METADATA") STORE AS SECUREFILE (
TABLESPACE "BACKBASEDATA" )
LOB ("ADDITIONS") STORE AS SECUREFILE (
TABLESPACE "BACKBASEDATA" )
STORAGE(
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "BACKBASEDATA"
COMPRESS BASIC ,
SUBPARTITION "SYS_SUBP13528" SEGMENT CREATION DEFERRED
LOB ("METADATA") STORE AS SECUREFILE (
TABLESPACE "BACKBASEDATA" )
LOB ("ADDITIONS") STORE AS SECUREFILE (
TABLESPACE "BACKBASEDATA" )
STORAGE(
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "BACKBASEDATA"
COMPRESS BASIC ,
SUBPARTITION "SYS_SUBP13529" SEGMENT CREATION DEFERRED
LOB ("METADATA") STORE AS SECUREFILE (
TABLESPACE "BACKBASEDATA" )
LOB ("ADDITIONS") STORE AS SECUREFILE (
TABLESPACE "BACKBASEDATA" )
STORAGE(
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "BACKBASEDATA"
COMPRESS BASIC ,
SUBPARTITION "SYS_SUBP13530" SEGMENT CREATION DEFERRED
LOB ("METADATA") STORE AS SECUREFILE (
TABLESPACE "BACKBASEDATA" )
LOB ("ADDITIONS") STORE AS SECUREFILE (
TABLESPACE "BACKBASEDATA" )
STORAGE(
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "BACKBASEDATA"
COMPRESS BASIC ,
SUBPARTITION "SYS_SUBP13531" SEGMENT CREATION DEFERRED
LOB ("METADATA") STORE AS SECUREFILE (
TABLESPACE "BACKBASEDATA" )
LOB ("ADDITIONS") STORE AS SECUREFILE (
TABLESPACE "BACKBASEDATA" )
STORAGE(
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "BACKBASEDATA"
COMPRESS BASIC ,
SUBPARTITION "SYS_SUBP13532" SEGMENT CREATION DEFERRED
LOB ("METADATA") STORE AS SECUREFILE (
TABLESPACE "BACKBASEDATA" )
LOB ("ADDITIONS") STORE AS SECUREFILE (
TABLESPACE "BACKBASEDATA" )
STORAGE(
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "BACKBASEDATA"
COMPRESS BASIC ,
SUBPARTITION "SYS_SUBP13533" SEGMENT CREATION DEFERRED
LOB ("METADATA") STORE AS SECUREFILE (
TABLESPACE "BACKBASEDATA" )
LOB ("ADDITIONS") STORE AS SECUREFILE (
TABLESPACE "BACKBASEDATA" )
STORAGE(
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "BACKBASEDATA"
COMPRESS BASIC ,
SUBPARTITION "SYS_SUBP13534" SEGMENT CREATION DEFERRED
LOB ("METADATA") STORE AS SECUREFILE (
TABLESPACE "BACKBASEDATA" )
LOB ("ADDITIONS") STORE AS SECUREFILE (
TABLESPACE "BACKBASEDATA" )
STORAGE(
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "BACKBASEDATA"
COMPRESS BASIC ,
SUBPARTITION "SYS_SUBP13535" SEGMENT CREATION DEFERRED
LOB ("METADATA") STORE AS SECUREFILE (
TABLESPACE "BACKBASEDATA" )
LOB ("ADDITIONS") STORE AS SECUREFILE (
TABLESPACE "BACKBASEDATA" )
STORAGE(
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "BACKBASEDATA"
COMPRESS BASIC ,
SUBPARTITION "SYS_SUBP13536" SEGMENT CREATION DEFERRED
LOB ("METADATA") STORE AS SECUREFILE (
TABLESPACE "BACKBASEDATA" )
LOB ("ADDITIONS") STORE AS SECUREFILE (
TABLESPACE "BACKBASEDATA" )
STORAGE(
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "BACKBASEDATA"
COMPRESS BASIC ,
SUBPARTITION "SYS_SUBP13537" SEGMENT CREATION DEFERRED
LOB ("METADATA") STORE AS SECUREFILE (
TABLESPACE "BACKBASEDATA" )
LOB ("ADDITIONS") STORE AS SECUREFILE (
TABLESPACE "BACKBASEDATA" )
STORAGE(
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "BACKBASEDATA"
COMPRESS BASIC ,
SUBPARTITION "SYS_SUBP13538" SEGMENT CREATION DEFERRED
LOB ("METADATA") STORE AS SECUREFILE (
TABLESPACE "BACKBASEDATA" )
LOB ("ADDITIONS") STORE AS SECUREFILE (
TABLESPACE "BACKBASEDATA" )
STORAGE(
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "BACKBASEDATA"
COMPRESS BASIC ,
SUBPARTITION "SYS_SUBP13539" SEGMENT CREATION DEFERRED
LOB ("METADATA") STORE AS SECUREFILE (
TABLESPACE "BACKBASEDATA" )
LOB ("ADDITIONS") STORE AS SECUREFILE (
TABLESPACE "BACKBASEDATA" )
STORAGE(
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "BACKBASEDATA"
COMPRESS BASIC ,
SUBPARTITION "SYS_SUBP13540" SEGMENT CREATION DEFERRED
LOB ("METADATA") STORE AS SECUREFILE (
TABLESPACE "BACKBASEDATA" )
LOB ("ADDITIONS") STORE AS SECUREFILE (
TABLESPACE "BACKBASEDATA" )
STORAGE(
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "BACKBASEDATA"
COMPRESS BASIC ,
SUBPARTITION "SYS_SUBP13541" SEGMENT CREATION DEFERRED
LOB ("METADATA") STORE AS SECUREFILE (
TABLESPACE "BACKBASEDATA" )
LOB ("ADDITIONS") STORE AS SECUREFILE (
TABLESPACE "BACKBASEDATA" )
STORAGE(
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "BACKBASEDATA"
COMPRESS BASIC ,
SUBPARTITION "SYS_SUBP13542" SEGMENT CREATION DEFERRED
LOB ("METADATA") STORE AS SECUREFILE (
TABLESPACE "BACKBASEDATA" )
LOB ("ADDITIONS") STORE AS SECUREFILE (
TABLESPACE "BACKBASEDATA" )
STORAGE(
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "BACKBASEDATA"
COMPRESS BASIC ,
SUBPARTITION "SYS_SUBP13543" SEGMENT CREATION DEFERRED
LOB ("METADATA") STORE AS SECUREFILE (
TABLESPACE "BACKBASEDATA" )
LOB ("ADDITIONS") STORE AS SECUREFILE (
TABLESPACE "BACKBASEDATA" )
STORAGE(
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "BACKBASEDATA"
COMPRESS BASIC ,
SUBPARTITION "SYS_SUBP13544" SEGMENT CREATION DEFERRED
LOB ("METADATA") STORE AS SECUREFILE (
TABLESPACE "BACKBASEDATA" )
LOB ("ADDITIONS") STORE AS SECUREFILE (
TABLESPACE "BACKBASEDATA" )
STORAGE(
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "BACKBASEDATA"
COMPRESS BASIC ,
SUBPARTITION "SYS_SUBP13545" SEGMENT CREATION DEFERRED
LOB ("METADATA") STORE AS SECUREFILE (
TABLESPACE "BACKBASEDATA" )
LOB ("ADDITIONS") STORE AS SECUREFILE (
TABLESPACE "BACKBASEDATA" )
STORAGE(
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "BACKBASEDATA"
COMPRESS BASIC ,
SUBPARTITION "SYS_SUBP13546" SEGMENT CREATION DEFERRED
LOB ("METADATA") STORE AS SECUREFILE (
TABLESPACE "BACKBASEDATA" )
LOB ("ADDITIONS") STORE AS SECUREFILE (
TABLESPACE "BACKBASEDATA" )
STORAGE(
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "BACKBASEDATA"
COMPRESS BASIC ,
SUBPARTITION "SYS_SUBP13547" SEGMENT CREATION DEFERRED
LOB ("METADATA") STORE AS SECUREFILE (
TABLESPACE "BACKBASEDATA" )
LOB ("ADDITIONS") STORE AS SECUREFILE (
TABLESPACE "BACKBASEDATA" )
STORAGE(
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "BACKBASEDATA"
COMPRESS BASIC ,
SUBPARTITION "SYS_SUBP13548" SEGMENT CREATION DEFERRED
LOB ("METADATA") STORE AS SECUREFILE (
TABLESPACE "BACKBASEDATA" )
LOB ("ADDITIONS") STORE AS SECUREFILE (
TABLESPACE "BACKBASEDATA" )
STORAGE(
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "BACKBASEDATA"
COMPRESS BASIC ,
SUBPARTITION "SYS_SUBP13549" SEGMENT CREATION DEFERRED
LOB ("METADATA") STORE AS SECUREFILE (
TABLESPACE "BACKBASEDATA" )
LOB ("ADDITIONS") STORE AS SECUREFILE (
TABLESPACE "BACKBASEDATA" )
STORAGE(
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "BACKBASEDATA"
COMPRESS BASIC ,
SUBPARTITION "SYS_SUBP13550" SEGMENT CREATION DEFERRED
LOB ("METADATA") STORE AS SECUREFILE (
TABLESPACE "BACKBASEDATA" )
LOB ("ADDITIONS") STORE AS SECUREFILE (
TABLESPACE "BACKBASEDATA" )
STORAGE(
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "BACKBASEDATA"
COMPRESS BASIC ,
SUBPARTITION "SYS_SUBP13551" SEGMENT CREATION DEFERRED
LOB ("METADATA") STORE AS SECUREFILE (
TABLESPACE "BACKBASEDATA" )
LOB ("ADDITIONS") STORE AS SECUREFILE (
TABLESPACE "BACKBASEDATA" )
STORAGE(
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "BACKBASEDATA"
COMPRESS BASIC ,
SUBPARTITION "SYS_SUBP13552" SEGMENT CREATION DEFERRED
LOB ("METADATA") STORE AS SECUREFILE (
TABLESPACE "BACKBASEDATA" )
LOB ("ADDITIONS") STORE AS SECUREFILE (
TABLESPACE "BACKBASEDATA" )
STORAGE(
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "BACKBASEDATA"
COMPRESS BASIC ,
SUBPARTITION "SYS_SUBP13553" SEGMENT CREATION DEFERRED
LOB ("METADATA") STORE AS SECUREFILE (
TABLESPACE "BACKBASEDATA" )
LOB ("ADDITIONS") STORE AS SECUREFILE (
TABLESPACE "BACKBASEDATA" )
STORAGE(
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "BACKBASEDATA"
COMPRESS BASIC ,
SUBPARTITION "SYS_SUBP13554" SEGMENT CREATION DEFERRED
LOB ("METADATA") STORE AS SECUREFILE (
TABLESPACE "BACKBASEDATA" )
LOB ("ADDITIONS") STORE AS SECUREFILE (
TABLESPACE "BACKBASEDATA" )
STORAGE(
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "BACKBASEDATA"
COMPRESS BASIC ,
SUBPARTITION "SYS_SUBP13555" SEGMENT CREATION DEFERRED
LOB ("METADATA") STORE AS SECUREFILE (
TABLESPACE "BACKBASEDATA" )
LOB ("ADDITIONS") STORE AS SECUREFILE (
TABLESPACE "BACKBASEDATA" )
STORAGE(
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "BACKBASEDATA"
COMPRESS BASIC ,
SUBPARTITION "SYS_SUBP13556" SEGMENT CREATION DEFERRED
LOB ("METADATA") STORE AS SECUREFILE (
TABLESPACE "BACKBASEDATA" )
LOB ("ADDITIONS") STORE AS SECUREFILE (
TABLESPACE "BACKBASEDATA" )
STORAGE(
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "BACKBASEDATA"
COMPRESS BASIC ,
SUBPARTITION "SYS_SUBP13557" SEGMENT CREATION DEFERRED
LOB ("METADATA") STORE AS SECUREFILE (
TABLESPACE "BACKBASEDATA" )
LOB ("ADDITIONS") STORE AS SECUREFILE (
TABLESPACE "BACKBASEDATA" )
STORAGE(
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "BACKBASEDATA"
COMPRESS BASIC ,
SUBPARTITION "SYS_SUBP13558" SEGMENT CREATION DEFERRED
LOB ("METADATA") STORE AS SECUREFILE (
TABLESPACE "BACKBASEDATA" )
LOB ("ADDITIONS") STORE AS SECUREFILE (
TABLESPACE "BACKBASEDATA" )
STORAGE(
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "BACKBASEDATA"
COMPRESS BASIC ) )
PARALLEL 32 ;
--------------------------------------------------------
-- DDL for Index PK_AUDIT_MESSAGETEST
--------------------------------------------------------
CREATE INDEX "AUDIT_PERSISTENCE"."PK_AUDIT_MESSAGETEST" ON "AUDIT_PERSISTENCE"."AUDIT_MESSAGETEST" ("EVENT_TIME", "ACTOR_USER_ID", "ID")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "BACKBASEDATA" ;
--------------------------------------------------------
-- DDL for Index IDX_AUDIT_MSG_ID2
--------------------------------------------------------
CREATE INDEX "AUDIT_PERSISTENCE"."IDX_AUDIT_MSG_ID2" ON "AUDIT_PERSISTENCE"."AUDIT_MESSAGETEST" ("ID")
PCTFREE 10 INITRANS 10 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "BACKBASEINDEX"
PARALLEL 16 ;
--------------------------------------------------------
-- DDL for Index IX_AUD_MESS_ACTOR_USER_ID2
--------------------------------------------------------
CREATE INDEX "AUDIT_PERSISTENCE"."IX_AUD_MESS_ACTOR_USER_ID2" ON "AUDIT_PERSISTENCE"."AUDIT_MESSAGETEST" ("ACTOR_USER_ID")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "BACKBASEDATA" ;
--------------------------------------------------------
-- DDL for Index IX_AUD_MESS_EMULATOR_USER_ID2
--------------------------------------------------------
CREATE INDEX "AUDIT_PERSISTENCE"."IX_AUD_MESS_EMULATOR_USER_ID2" ON "AUDIT_PERSISTENCE"."AUDIT_MESSAGETEST" ("EMULATOR_USER_ID")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "BACKBASEDATA" ;
--------------------------------------------------------
-- Constraints for Table AUDIT_MESSAGETEST
--------------------------------------------------------
ALTER TABLE "AUDIT_PERSISTENCE"."AUDIT_MESSAGETEST" MODIFY ("ID" NOT NULL ENABLE);
ALTER TABLE "AUDIT_PERSISTENCE"."AUDIT_MESSAGETEST" MODIFY ("STATUS" NOT NULL ENABLE);
ALTER TABLE "AUDIT_PERSISTENCE"."AUDIT_MESSAGETEST" MODIFY ("EVENT_TIME" NOT NULL ENABLE);
ALTER TABLE "AUDIT_PERSISTENCE"."AUDIT_MESSAGETEST" MODIFY ("ACTOR_USER_ID" NOT NULL ENABLE);
ALTER TABLE "AUDIT_PERSISTENCE"."AUDIT_MESSAGETEST" MODIFY ("ACTOR_USERNAME" NOT NULL ENABLE);
ALTER TABLE "AUDIT_PERSISTENCE"."AUDIT_MESSAGETEST" MODIFY ("EVENT_CATEGORY" NOT NULL ENABLE);
ALTER TABLE "AUDIT_PERSISTENCE"."AUDIT_MESSAGETEST" MODIFY ("OBJECT_TYPE" NOT NULL ENABLE);
ALTER TABLE "AUDIT_PERSISTENCE"."AUDIT_MESSAGETEST" MODIFY ("EVENT_ACTION" NOT NULL ENABLE);
ALTER TABLE "AUDIT_PERSISTENCE"."AUDIT_MESSAGETEST" MODIFY ("EVENT_DESC" NOT NULL ENABLE);