--------------------------------------------------------
--  DDL for Table SRC_CMDB_NEXT_EXA_CDB_TB
--------------------------------------------------------

CREATE TABLE "OTHQ_OWN"."SRC_CMDB_NEXT_EXA_CDB_TB" (
    "ID"                           VARCHAR2(32 BYTE) NOT NULL,
    "SCAN_NAME"                    VARCHAR2(128 BYTE),
    "DB_INSTANCE"                  VARCHAR2(32 BYTE),
    "AVAILABILITY_DOMAIN"          VARCHAR2(32 BYTE),
    "LOGICAL_DATA_CENTER"          VARCHAR2(64 BYTE),
    "MOLECULE"                     VARCHAR2(32 BYTE),
    "VERSION"                      VARCHAR2(16 BYTE),
    "GROUP"                        VARCHAR2(16 BYTE),
    "OPERATING_STATUS"             VARCHAR2(16 BYTE),
    "EXA_CLUSTER_INSTANCE_SHAPE"   VARCHAR2(32 BYTE),
    "PDB_COUNT"                    NUMBER,
    "PDBS_IN_SMD"                  NUMBER,
    "PDB_CAPACITY"                 NUMBER,
    "PDB_SIZE"                     NUMBER,
    "RESOURCE_USER"                VARCHAR2(32 BYTE),
    "DATAGUARD_STATUS"             VARCHAR2(16 BYTE),
    "EXA_CLUSTER_CREATED"          DATE

    CONSTRAINT "SRC_CMDB_NEXT_EXA_CDB_TB_PK" PRIMARY KEY ("ID")
  );

--------------------------------------------------------
--  DDL for Index SRC_CMDB_NEXT_EXA_CDB_TB_PK
--------------------------------------------------------
  CREATE UNIQUE INDEX "OTHQ_OWN"."SRC_CMDB_NEXT_EXA_CDB_TB_PK" ON "OTHQ_OWN"."SRC_CMDB_NEXT_EXA_CDB_TB" ("ID") 
  PCTFREE 10 INITRANS 20 MAXTRANS 255 
  TABLESPACE "DATA" ;