CREATE TABLE "OTHQ_OWN"."ARCHIVE_OSEARCH_WEBSERVICESEXECUTION_RABI_DAILY_TB"
(
	"DOC_COUNT" NUMBER,
	"TIMESTAMP" DATE,
	"INDEX_" VARCHAR2(64 BYTE),
	"STYPE" VARCHAR2(16 BYTE),
	"SRECORDTYPE" VARCHAR2(512 BYTE),
	"KINTEGRATIONAPPLICATIONDEF" NUMBER,
	"SACCOUNTTYPE" VARCHAR2(16 BYTE),
	"SAUTHENTICATIONMETHOD" VARCHAR2(32 BYTE),
	"SINTEGRATIONAPPLICATIONNAME" VARCHAR2(128 BYTE),
	"SACTION" VARCHAR2(32 BYTE),
	"SDCID" VARCHAR2(16 BYTE),
	"SAPIVERSION" VARCHAR2(8 BYTE),
	"SSTATE" VARCHAR2(16 BYTE),
	"SCOMPID" VARCHAR2(32 BYTE),
	"NRESPONSECODE" NUMBER,
	"SSERVICETYPE" VARCHAR2(8 BYTE),
	"METADATA_REGION" VARCHAR2(8 BYTE),
	"SINTEGRATIONAPPLICATIONID" VARCHAR2(64 BYTE),
	"SINTEGRATIONAPPLICATIONSCRIPTID" VARCHAR2(32 BYTE),
    CONSTRAINT ARCHIVE_OSEARCH_WEBSERVICESEXECUTION_RABI_DAILY_TB_PK
    PRIMARY KEY ("TIMESTAMP", METADATA_REGION, SACTION, SRECORDTYPE, SACCOUNTTYPE, SCOMPID, STYPE) USING INDEX LOCAL
) PARTITION BY RANGE ("TIMESTAMP") INTERVAL (NUMTODSINTERVAL(1, 'DAY')) (PARTITION p_2025_03_30 VALUES LESS THAN (DATE '2025-03-31'));
