DBAdmin Tables


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

) ;

 

Leave a Reply

Your email address will not be published. Required fields are marked *