CREATE TABLE "CT"
( "CT_ID" NUMBER,
"CT_CD_TR" VARCHAR2(4000),
"CT_LCL_HM_LNK" VARCHAR2(4000),
"CT_HST" VARCHAR2(10),
"CT_DB" VARCHAR2(10),
"CT_ASGN_TO" VARCHAR2(4000),
"CT_ASGN_DT" VARCHAR2(4000),
"CT_ASGN_BY" VARCHAR2(4000),
"CT_CMTS" CLOB,
"CT_ACFS_HOME" VARCHAR2(4000),
"CT_CLS" VARCHAR2(4000)
) ;
CREATE TABLE "CUSTOMER"
( "CST_ID" NUMBER,
"CST_NM" VARCHAR2(100),
"CST_TP" NUMBER,
"CST_TEL_NBR" VARCHAR2(15),
"CST_EML" VARCHAR2(100),
"CST_CMT" VARCHAR2(4000),
"CST_PRI_CNT" VARCHAR2(75),
"CST_PRI_TEL" VARCHAR2(15),
"CST_PRI_EML" VARCHAR2(100),
"CST_LOB" VARCHAR2(20),
"CST_DPT" VARCHAR2(20),
"CST_BUS_OWR" VARCHAR2(20),
"CST_PYMT_TP" VARCHAR2(3)
) ;CREATE TABLE "DATABASE"
( "DB_ID" VARCHAR2(10),
"DB_NM" VARCHAR2(20),
"DB_DSCR" VARCHAR2(1000),
"DB_CMT" VARCHAR2(4000),
"DB_QADT" DATE,
"DB_INST_NM" VARCHAR2(15),
"DB_TP" VARCHAR2(3),
"DB_VER" VARCHAR2(15),
"DB_OS" VARCHAR2(4),
"DB_OS_VER" VARCHAR2(3),
"DB_UPG_VER" VARCHAR2(10),
"DB_UPG_STAT" VARCHAR2(3),
"DB_DBA_CRT" VARCHAR2(4),
"DB_APL" VARCHAR2(4),
"DB_DBA_CUR" VARCHAR2(4),
"DB_CRT_DT" DATE,
"DB_DT_NXT_UPG" DATE,
"DB_DT_UPG" DATE,
"DB_CMP" VARCHAR2(3),
"DB_DBA_PRIM" VARCHAR2(4),
"DB_DBA_SECD" VARCHAR2(4),
"DB_CST_ID" NUMBER,
"DB_CPU" NUMBER,
"DB_DSK_USED" NUMBER,
"DB_DSK_ALLOC" NUMBER,
"DB_MEM_PGA" NUMBER,
"DB_MEM_SGA" NUMBER,
"DB_MEM_TGT" NUMBER,
"DB_DBID" VARCHAR2(25),
"DB_BKP_FRQ" VARCHAR2(2000),
"DB_SVC_NM" VARCHAR2(50),
"DB_CAT_TP" VARCHAR2(35),
"DB_DBA_LU" VARCHAR2(25),
"DB_DBA_NU" VARCHAR2(25),
"DB_MCH_ID" VARCHAR2(10),
"DB_DT_DECOMM" DATE,
"DB_STORM" VARCHAR2(4000),
"DB_UNQ_NM" VARCHAR2(20),
"DB_AIT" VARCHAR2(20),
"DB_STO_DATA" NUMBER,
"DB_STO_SYS" NUMBER,
"DB_STO_FRA" NUMBER,
"DB_UPG_CMTS" CLOB,
"DB_PRCS" NUMBER,
"DB_SESS" NUMBER,
"DB_QST" VARCHAR2(4000),
"DB_HC_DBID" NUMBER,
"DB_STO_DATA_USD" NUMBER,
"DB_STO_FRA_USD" NUMBER,
"DB_STO_SYS_USD" NUMBER,
"DB_AUD_TP" VARCHAR2(50),
"DB_BCK" VARCHAR2(1),
"DB_SQLT" VARCHAR2(1),
"DB_CRTAB" VARCHAR2(1),
"DB_DDL" VARCHAR2(1),
"DB_ENV" VARCHAR2(1),
"DB_RMAN_ARGS" VARCHAR2(1),
"DB_RON_FO_TST" VARCHAR2(1),
"DB_RISK_RTG" VARCHAR2(4000),
"DB_NA_DT" DATE,
"DB_VFY_ASM" VARCHAR2(1),
"DB_DBCA" VARCHAR2(1),
"DB_DBCA_SL" VARCHAR2(4000),
"DB_TST_NWS" VARCHAR2(1),
"DB_ESM" VARCHAR2(1),
"DB_TST_CNCT" VARCHAR2(1),
"DB_PORT" VARCHAR2(4000),
"DB_HST" VARCHAR2(4000),
"DB_SVC_NM02" VARCHAR2(4000),
"DB_LOG_CLN" VARCHAR2(1),
"DB_LSN_CLN" VARCHAR2(1),
"DB_CRON_TXT" VARCHAR2(4000),
"DB_CLN_RUN" VARCHAR2(1),
"DB_MON_TST" VARCHAR2(1),
"DB_MRD" VARCHAR2(1),
"DB_SPM" VARCHAR2(1),
"DB_AWR" VARCHAR2(1),
"DB_INST_CG" VARCHAR2(3),
"DB_FOG" VARCHAR2(1),
"DB_SPT" VARCHAR2(1),
"DB_ORATAB" VARCHAR2(1),
"DB_90_CFG" VARCHAR2(1),
"DB_100_TBSPC" VARCHAR2(1),
"DB_QA_CMTS" CLOB,
"DB_STO_SAUX" NUMBER,
"DB_STO_SAUX_USD" NUMBER,
"DB_STO_USERS" NUMBER,
"DB_STO_USERS_USD" NUMBER,
"DB_STO_UNDO" NUMBER,
"DB_STO_UNDO_USD" NUMBER,
"DB_STO_TOOLS" NUMBER,
"DB_STO_TOOLS_USD" NUMBER,
"DB_STO_TEMP" NUMBER,
"DB_STO_TEMP_USD" NUMBER,
"DB_STO_ONREDO" NUMBER,
"DB_STO_ONREDO_USD" NUMBER,
"DB_LOB" VARCHAR2(4000),
"DB_STO_DT" DATE,
"DB_LST_UPDT" DATE,
"DB_VNCR" VARCHAR2(1),
"DB_STAT_JOB" VARCHAR2(1),
"DB_TAPE_BCKUP" VARCHAR2(1),
"DB_ARCH_APP" VARCHAR2(100),
"DB_MGMT_APP" VARCHAR2(100),
"DB_HM_LOC" VARCHAR2(4000),
"DB_HM_SZ" NUMBER,
"DB_HM_SZ_REM" NUMBER,
"DB_QA_APP" VARCHAR2(4000),
"DB_QA_APP_REQ" VARCHAR2(4000),
"DB_QA_APP_DT" DATE,
"DB_SF_SUX" NUMBER,
"DB_SF_SYS" NUMBER,
"DB_SF_UNDO" NUMBER,
"DB_SF_TTMP" NUMBER,
"DB_SF_USR" NUMBER,
"DB_SF_TLS" NUMBER,
"DB_SF_DTA" NUMBER,
"DB_SF_OR01" NUMBER,
"DB_SF_SR01" NUMBER,
"DB_SF_SR02" NUMBER,
"DB_SF_BCK" NUMBER,
"DB_SF_ALF" NUMBER,
"DB_SF_OR02" NUMBER,
"DB_QA_DOC_LNK" VARCHAR2(4000),
"DB_FTS" VARCHAR2(4000),
"DB_AUTO_JOBS" VARCHAR2(4000),
"DB_QA_SA_DSK_UPD" VARCHAR2(4000),
"DB_100_TBSPC_CR" VARCHAR2(4000),
"DB_DC_CLS" VARCHAR2(4000),
"DB_DC_APP" VARCHAR2(4000),
"DB_DC_AIT" VARCHAR2(4000),
"DB_DC_AUTH" VARCHAR2(4000),
"DB_DC_BCK_HR_MM" VARCHAR2(4000),
"DB_DC_ORA_VER" VARCHAR2(4000),
"DB_DC_BBDA_TMPLT" VARCHAR2(4000),
"DB_DC_RGN" VARCHAR2(4000),
"DB_DC_RMN_CAT" VARCHAR2(4000),
"DB_DC_PRI_DBA" VARCHAR2(4000),
"DB_DC_SCN_DBA" VARCHAR2(4000),
"DB_DC_ORA_ID" VARCHAR2(4000),
"DB_DC_PRI_SA" VARCHAR2(4000),
"DB_DC_SA_GRP" VARCHAR2(4000),
"DB_DC_APP_OWN" VARCHAR2(4000),
"DB_DC_APP_SLA" VARCHAR2(4000),
"DB_DC_ACC_TP" VARCHAR2(4000),
"DB_DC_FRA" VARCHAR2(4000),
"DB_DC_ALM" VARCHAR2(4000),
"DB_DC_FL_MGT_SRV" VARCHAR2(4000),
"DB_DC_HM" VARCHAR2(4000),
"DB_DC_DBA_SPRT_GRP" VARCHAR2(4000),
"DB_DC_ADT_RSK_LVL" VARCHAR2(4000),
"DB_DC_CH_SET" VARCHAR2(4000),
"DB_DC_NTL_CH_SET" VARCHAR2(4000),
"DB_DC_CMP_LVL" VARCHAR2(4000),
"DB_DC_SYS_PWD" VARCHAR2(4000),
"DB_DC_ASM" VARCHAR2(4000),
"DB_DC_RMT_PWDFL" VARCHAR2(4000),
"DB_DC_MAX_PRC" VARCHAR2(4000),
"DB_DC_MAX_OPEN_CUR" VARCHAR2(4000),
"DB_MEM_FCST" NUMBER,
"DB_CPU_FCST" NUMBER,
"DB_DC_APPABR" VARCHAR2(5),
"DB_ROLE" VARCHAR2(4000),
"DB_DC_AWR_DYS" NUMBER,
CONSTRAINT "DATABASE_PK" PRIMARY KEY ("DB_ID")
USING INDEX ENABLE
) ;