--------------------------------------------------------
--  DDL for Table ON_DEMAND_OCI_TAGS_TB
--------------------------------------------------------

  CREATE TABLE "OTHQ_OWN"."ON_DEMAND_OCI_TAGS_TB" 
   (	"RESOURCEID" VARCHAR2(256 BYTE) COLLATE "USING_NLS_COMP", 
	"TAG_NAME" VARCHAR2(128 BYTE) COLLATE "USING_NLS_COMP", 
	"TAG_VALUE" VARCHAR2(512 BYTE) COLLATE "USING_NLS_COMP"
   )  DEFAULT COLLATION "USING_NLS_COMP" SEGMENT CREATION DEFERRED 
  PCTFREE 10 PCTUSED 40 INITRANS 10 MAXTRANS 255 
 COLUMN STORE COMPRESS FOR QUERY HIGH ROW LEVEL LOCKING LOGGING
  TABLESPACE "DATA" ;
--------------------------------------------------------
--  DDL for Index SYS_C0041384
--------------------------------------------------------

  CREATE UNIQUE INDEX "OTHQ_OWN"."SYS_C0041384" ON "OTHQ_OWN"."ON_DEMAND_OCI_TAGS_TB" ("RESOURCEID", "TAG_NAME") 
  PCTFREE 10 INITRANS 20 MAXTRANS 255 
  TABLESPACE "DATA" ;
--------------------------------------------------------
--  Constraints for Table ON_DEMAND_OCI_TAGS_TB
--------------------------------------------------------

  ALTER TABLE "OTHQ_OWN"."ON_DEMAND_OCI_TAGS_TB" ADD PRIMARY KEY ("RESOURCEID", "TAG_NAME")
  USING INDEX PCTFREE 10 INITRANS 20 MAXTRANS 255 
  TABLESPACE "DATA"  ENABLE;
