drop PROCEDURE MDMADM.D2_MV_REFRESH_PROC;
drop SEQUENCE MDMADM.CIFKVALSEQ;
drop SEQUENCE MDMADM.CI_LOGID_SEQ;
drop SEQUENCE MDMADM.CI_NTUPID_SEQ;
drop SEQUENCE MDMADM.F1_COL_SEQ;
drop SEQUENCE CCBADM.CIFKVALSEQ;
drop SEQUENCE CCBADM.CI_LOGID_SEQ;
drop SEQUENCE CCBADM.CI_NTUPID_SEQ;
drop SEQUENCE CCBADM.F1_COL_SEQ;
drop SEQUENCE CCBADM.CISEEDSEQ;
drop SEQUENCE CCBADM.CI_MRSTGUPID_SEQ;
drop SEQUENCE CCBADM.CI_WFM_MSGID_SEQ;
drop SEQUENCE CCBADM.CM_SHORT_DATAFLOWID_SEQ;
drop SEQUENCE CCBADM.CM_LONG_DATAFLOWID_SEQ;
drop TABLE CCBADM.CI_ARC_ROOT_INST_K cascade constraints;
drop TABLE CCBADM.CI_ARC_ROOT_OBJ_K cascade constraints;
drop TABLE CCBADM.CI_AUDIT_K cascade constraints;
drop TABLE CCBADM.CI_BATCH_JOB_K cascade constraints;
drop TABLE CCBADM.CI_NT_DWN_K cascade constraints;
drop TABLE CCBADM.CI_ROOT_INSTR_K cascade constraints;
drop TABLE CCBADM.CI_ROOT_OBJ_K cascade constraints;
drop TABLE CCBADM.CI_TD_ENTRY_K cascade constraints;
drop TABLE CCBADM.CI_WF_PROC_K cascade constraints;
drop TABLE CCBADM.CI_WF_PROC_SCHED_K cascade constraints;
drop TABLE CCBADM.F1_BNDL_K cascade constraints;
drop TABLE CCBADM.F1_BUS_EVT_LOG_K cascade constraints;
drop TABLE CCBADM.F1_FACT_K cascade constraints;
drop TABLE CCBADM.F1_GEN_PROC_K cascade constraints;
drop TABLE CCBADM.F1_MIGR_DATA_ST_K cascade constraints;
drop TABLE CCBADM.F1_MIGR_OBJ_K cascade constraints;
drop TABLE CCBADM.F1_MIGR_TRANS_K cascade constraints;
drop TABLE CCBADM.F1_OUTMSG_K cascade constraints;
drop TABLE CCBADM.F1_REQ_K cascade constraints;
drop TABLE CCBADM.F1_SVC_TASK_K cascade constraints;
drop TABLE CCBADM.F1_SYNC_REQ_IN_K cascade constraints;
drop TABLE CCBADM.F1_SYNC_REQ_K cascade constraints;
drop TABLE CCBADM.C1_LEAD_EVT_K cascade constraints;
drop TABLE CCBADM.C1_LEAD_K cascade constraints;
drop TABLE CCBADM.C1_OFFCYC_BGEN_K cascade constraints;
drop TABLE CCBADM.C1_TOU_MAP_K cascade constraints;
drop TABLE CCBADM.C1_USAGE_K cascade constraints;
drop TABLE CCBADM.CI_ACCT_APAY_K cascade constraints;
drop TABLE CCBADM.CI_ACCT_K cascade constraints;
drop TABLE CCBADM.CI_ADJ_APREQ_K cascade constraints;
drop TABLE CCBADM.CI_ADJ_K cascade constraints;
drop TABLE CCBADM.CI_AM_REQ_K cascade constraints;
drop TABLE CCBADM.CI_APAY_CLR_STG_K cascade constraints;
drop TABLE CCBADM.CI_APPR_REQ_K cascade constraints;
drop TABLE CCBADM.CI_BILL_CHG_K cascade constraints;
drop TABLE CCBADM.CI_BILL_K cascade constraints;
drop TABLE CCBADM.CI_BILL_SCNR_K cascade constraints;
drop TABLE CCBADM.CI_BPRT_GRP_K cascade constraints;
drop TABLE CCBADM.CI_BSEG_K cascade constraints;
drop TABLE CCBADM.CI_CASE_K cascade constraints;
drop TABLE CCBADM.CI_CC_K cascade constraints;
drop TABLE CCBADM.CI_CC_LOG_K cascade constraints;
drop TABLE CCBADM.CI_COLL_AGY_REF_K cascade constraints;
drop TABLE CCBADM.CI_COLL_PROC_K cascade constraints;
drop TABLE CCBADM.CI_COP_EVT_K cascade constraints;
drop TABLE CCBADM.CI_COP_K cascade constraints;
drop TABLE CCBADM.CI_CR_RAT_HIST_K cascade constraints;
drop TABLE CCBADM.CI_CUT_PROC_K cascade constraints;
drop TABLE CCBADM.CI_DCL_K cascade constraints;
drop TABLE CCBADM.CI_DEP_CTL_K cascade constraints;
drop TABLE CCBADM.CI_DG_APP_SCHED_K cascade constraints;
drop TABLE CCBADM.CI_DV_TEST_K cascade constraints;
drop TABLE CCBADM.CI_DV_TEST_SEL_K cascade constraints;
drop TABLE CCBADM.CI_ENRL_K cascade constraints;
drop TABLE CCBADM.CI_FA_K cascade constraints;
drop TABLE CCBADM.CI_FO_K cascade constraints;
drop TABLE CCBADM.CI_FT_K cascade constraints;
drop TABLE CCBADM.CI_INTV_DATA_SET_K cascade constraints;
drop TABLE CCBADM.CI_INTV_PF_K cascade constraints;
drop TABLE CCBADM.CI_INTV_VAL_SET_K cascade constraints;
drop TABLE CCBADM.CI_ITEM_K cascade constraints;
drop TABLE CCBADM.CI_ITEM_LOC_HIS_K cascade constraints;
drop TABLE CCBADM.CI_LANDLORD_K cascade constraints;
drop TABLE CCBADM.CI_MATCH_EVT_K cascade constraints;
drop TABLE CCBADM.CI_MR_K cascade constraints;
drop TABLE CCBADM.CI_MTR_CONFIG_K cascade constraints;
drop TABLE CCBADM.CI_MTR_K cascade constraints;
drop TABLE CCBADM.CI_MTR_LOC_HIS_K cascade constraints;
drop TABLE CCBADM.CI_NB_SCHED_PAY_K cascade constraints;
drop TABLE CCBADM.CI_OD_PROC_K cascade constraints;
drop TABLE CCBADM.CI_PAY_EVENT_K cascade constraints;
drop TABLE CCBADM.CI_PAY_K cascade constraints;
drop TABLE CCBADM.CI_PAY_SEG_K cascade constraints;
drop TABLE CCBADM.CI_PAY_TNDR_K cascade constraints;
drop TABLE CCBADM.CI_PER_K cascade constraints;
drop TABLE CCBADM.CI_PKG_K cascade constraints;
drop TABLE CCBADM.CI_PP_K cascade constraints;
drop TABLE CCBADM.CI_PREM_K cascade constraints;
drop TABLE CCBADM.CI_PRM_ALT_ADDR_K cascade constraints;
drop TABLE CCBADM.CI_QUOTE_DTL_K cascade constraints;
drop TABLE CCBADM.CI_QUOTE_K cascade constraints;
drop TABLE CCBADM.CI_REBATE_CLAIM_K cascade constraints;
drop TABLE CCBADM.CI_REG_DATA_SET_K cascade constraints;
drop TABLE CCBADM.CI_REG_K cascade constraints;
drop TABLE CCBADM.CI_REG_READ_K cascade constraints;
drop TABLE CCBADM.CI_SA_COP_K cascade constraints;
drop TABLE CCBADM.CI_SA_K cascade constraints;
drop TABLE CCBADM.CI_SA_REL_K cascade constraints;
drop TABLE CCBADM.CI_SA_SP_K cascade constraints;
drop TABLE CCBADM.CI_SCM_K cascade constraints;
drop TABLE CCBADM.CI_SC_EVT_FT_K cascade constraints;
drop TABLE CCBADM.CI_SC_EVT_K cascade constraints;
drop TABLE CCBADM.CI_SEV_PROC_K cascade constraints;
drop TABLE CCBADM.CI_SP_ITEM_HIST_K cascade constraints;
drop TABLE CCBADM.CI_SP_K cascade constraints;
drop TABLE CCBADM.CI_SP_MTR_HIST_K cascade constraints;
drop TABLE CCBADM.CI_STM_CNST_DTL_K cascade constraints;
drop TABLE CCBADM.CI_STM_CNST_K cascade constraints;
drop TABLE CCBADM.CI_STM_DTL_K cascade constraints;
drop TABLE CCBADM.CI_STM_K cascade constraints;
drop TABLE CCBADM.CI_SVC_RTE_STG_DWN_K cascade constraints;
drop TABLE CCBADM.CI_TNDR_CTL_K cascade constraints;
drop TABLE CCBADM.CI_TNDR_DEP_K cascade constraints;
drop TABLE CCBADM.CI_TOS_K cascade constraints;
drop TABLE CCBADM.CI_TOU_DATA_SET_K cascade constraints;
drop TABLE CCBADM.CI_TOU_MAP_K cascade constraints;
drop TABLE CCBADM.CI_TURN_IN_K cascade constraints;
drop TABLE CCBADM.CI_UA_K cascade constraints;
drop TABLE CCBADM.CI_WO_PROC_K cascade constraints;
drop TABLE MDMADM.CI_ARC_ROOT_INST_K cascade constraints;
drop TABLE MDMADM.CI_ARC_ROOT_OBJ_K cascade constraints;
drop TABLE MDMADM.CI_AUDIT_K cascade constraints;
drop TABLE MDMADM.CI_BATCH_JOB_K cascade constraints;
drop TABLE MDMADM.CI_NT_DWN_K cascade constraints;
drop TABLE MDMADM.CI_ROOT_INSTR_K cascade constraints;
drop TABLE MDMADM.CI_ROOT_OBJ_K cascade constraints;
drop TABLE MDMADM.CI_TD_ENTRY_K cascade constraints;
drop TABLE MDMADM.CI_WF_PROC_K cascade constraints;
drop TABLE MDMADM.CI_WF_PROC_SCHED_K cascade constraints;
drop TABLE MDMADM.F1_BNDL_K cascade constraints;
drop TABLE MDMADM.F1_BUS_EVT_LOG_K cascade constraints;
drop TABLE MDMADM.F1_FACT_K cascade constraints;
drop TABLE MDMADM.F1_GEN_PROC_K cascade constraints;
drop TABLE MDMADM.F1_MIGR_DATA_ST_K cascade constraints;
drop TABLE MDMADM.F1_MIGR_OBJ_K cascade constraints;
drop TABLE MDMADM.F1_MIGR_TRANS_K cascade constraints;
drop TABLE MDMADM.F1_OUTMSG_K cascade constraints;
drop TABLE MDMADM.F1_REQ_K cascade constraints;
drop TABLE MDMADM.F1_SVC_TASK_K cascade constraints;
drop TABLE MDMADM.F1_SYNC_REQ_IN_K cascade constraints;
drop TABLE MDMADM.F1_SYNC_REQ_K cascade constraints;
drop TABLE MDMADM.D1_ACTIVITY_K cascade constraints;
drop TABLE MDMADM.D1_COMM_IN_K cascade constraints;
drop TABLE MDMADM.D1_COMM_OUT_K cascade constraints;
drop TABLE MDMADM.D1_COMPL_EVT_K cascade constraints;
drop TABLE MDMADM.D1_CONTACT_K cascade constraints;
drop TABLE MDMADM.D1_DVC_CFG_K cascade constraints;
drop TABLE MDMADM.D1_DVC_EVT_K cascade constraints;
drop TABLE MDMADM.D1_DVC_K cascade constraints;
drop TABLE MDMADM.D1_DYN_OPT_EVENT_K cascade constraints;
drop TABLE MDMADM.D1_DYN_OPT_K cascade constraints;
drop TABLE MDMADM.D1_INIT_MSRMT_DATA_K cascade constraints;
drop TABLE MDMADM.D1_INSTALL_EVT_K cascade constraints;
drop TABLE MDMADM.D1_MEASR_COMP_K cascade constraints;
drop TABLE MDMADM.D1_SP_K cascade constraints;
drop TABLE MDMADM.D1_TOU_MAP_K cascade constraints;
drop TABLE MDMADM.D1_USAGE_K cascade constraints;
drop TABLE MDMADM.D1_US_K cascade constraints;
drop TABLE MDMADM.D1_VEE_EXCP_K cascade constraints;
drop TABLE CCBADM.CI_UT_INSTL cascade constraints;
drop TABLE CCBADM.CI_UT_INSTL_DTL cascade constraints;
drop TABLE CCBADM.CI_MD_TBL cascade constraints;
drop TABLE CCBADM.CI_ACC_GRP cascade constraints;
drop TABLE CCBADM.CI_ACC_GRP_DAR cascade constraints;
drop TABLE CCBADM.CI_ACC_GRP_L cascade constraints;
drop TABLE CCBADM.CI_ALG cascade constraints;
drop TABLE CCBADM.CI_ALG_L cascade constraints;
drop TABLE CCBADM.CI_ALG_PARM cascade constraints;
drop TABLE CCBADM.CI_ALG_TYPE cascade constraints;
drop TABLE CCBADM.CI_ALG_TYPE_L cascade constraints;
drop TABLE CCBADM.CI_ALG_TYPE_PRM cascade constraints;
drop TABLE CCBADM.CI_ALG_TYPE_PRM_L cascade constraints;
drop TABLE CCBADM.CI_ALG_VER cascade constraints;
drop TABLE CCBADM.CI_APP_SVC_ACC cascade constraints;
drop TABLE CCBADM.CI_APP_SVC_SCTY cascade constraints;
drop TABLE CCBADM.CI_ARC_ROOT_INST cascade constraints;
drop TABLE CCBADM.CI_ARC_ROOT_OBJ cascade constraints;
drop TABLE CCBADM.CI_ARC_ROOT_PK cascade constraints;
drop TABLE CCBADM.CI_AUDIT cascade constraints;
drop TABLE CCBADM.CI_BATCH_CTRL cascade constraints;
drop TABLE CCBADM.CI_BATCH_CTRL_ALG cascade constraints;
drop TABLE CCBADM.CI_BATCH_CTRL_L cascade constraints;
drop TABLE CCBADM.CI_BATCH_CTRL_P cascade constraints;
drop TABLE CCBADM.CI_BATCH_CTRL_P_L cascade constraints;
drop TABLE CCBADM.CI_BATCH_INST cascade constraints;
drop TABLE CCBADM.CI_BATCH_JOB cascade constraints;
drop TABLE CCBADM.CI_BATCH_JOB_PRM cascade constraints;
drop TABLE CCBADM.CI_BATCH_RUN cascade constraints;
drop TABLE CCBADM.CI_BATCH_THD cascade constraints;
drop TABLE CCBADM.CI_CAL_HOL cascade constraints;
drop TABLE CCBADM.CI_CAL_HOL_L cascade constraints;
drop TABLE CCBADM.CI_CAL_WORK cascade constraints;
drop TABLE CCBADM.CI_CAL_WORK_L cascade constraints;
drop TABLE CCBADM.CI_CHAR_ENTITY cascade constraints;
drop TABLE CCBADM.CI_CHAR_TYPE cascade constraints;
drop TABLE CCBADM.CI_CHAR_TYPE_L cascade constraints;
drop TABLE CCBADM.CI_CHAR_VAL cascade constraints;
drop TABLE CCBADM.CI_CHAR_VAL_L cascade constraints;
drop TABLE CCBADM.CI_CHTY_TDTY cascade constraints;
drop TABLE CCBADM.CI_CNV_DUP_KEY cascade constraints;
drop TABLE CCBADM.CI_CNV_KEY_TMP cascade constraints;
drop TABLE CCBADM.CI_COUNTRY cascade constraints;
drop TABLE CCBADM.CI_COUNTRY_L cascade constraints;
drop TABLE CCBADM.CI_CURRENCY_CD cascade constraints;
drop TABLE CCBADM.CI_CURRENCY_CD_L cascade constraints;
drop TABLE CCBADM.CI_DAR cascade constraints;
drop TABLE CCBADM.CI_DAR_L cascade constraints;
drop TABLE CCBADM.CI_DAR_USR cascade constraints;
drop TABLE CCBADM.CI_DATA_DIFF cascade constraints;
drop TABLE CCBADM.CI_DATA_DIFF_PK cascade constraints;
drop TABLE CCBADM.CI_DB_INSTR cascade constraints;
drop TABLE CCBADM.CI_DB_INSTR_ALG cascade constraints;
drop TABLE CCBADM.CI_DB_INSTR_L cascade constraints;
drop TABLE CCBADM.CI_DB_INST_OVRD cascade constraints;
drop TABLE CCBADM.CI_DB_PROC cascade constraints;
drop TABLE CCBADM.CI_DB_PROC_L cascade constraints;
drop TABLE CCBADM.CI_DISP_ICON cascade constraints;
drop TABLE CCBADM.CI_DISP_ICON_L cascade constraints;
drop TABLE CCBADM.CI_DISP_PROF cascade constraints;
drop TABLE CCBADM.CI_DISP_PROF_L cascade constraints;
drop TABLE CCBADM.CI_ENV_REF cascade constraints;
drop TABLE CCBADM.CI_ENV_REF_L cascade constraints;
drop TABLE CCBADM.CI_FK_REF cascade constraints;
drop TABLE CCBADM.CI_FK_REF_L cascade constraints;
drop TABLE CCBADM.CI_FUNC cascade constraints;
drop TABLE CCBADM.CI_FUNC_FLD cascade constraints;
drop TABLE CCBADM.CI_FUNC_FLD_L cascade constraints;
drop TABLE CCBADM.CI_FUNC_L cascade constraints;
drop TABLE CCBADM.CI_GEO_TYPE cascade constraints;
drop TABLE CCBADM.CI_GEO_TYPE_L cascade constraints;
drop TABLE CCBADM.CI_INSTALL_ALG cascade constraints;
drop TABLE CCBADM.CI_INSTALL_MSG cascade constraints;
drop TABLE CCBADM.CI_INSTALL_MSG_L cascade constraints;
drop TABLE CCBADM.CI_INSTALL_PROD cascade constraints;
drop TABLE CCBADM.CI_LANGUAGE cascade constraints;
drop TABLE CCBADM.CI_LOOKUP_FIELD cascade constraints;
drop TABLE CCBADM.CI_LOOKUP_VAL cascade constraints;
drop TABLE CCBADM.CI_LOOKUP_VAL_L cascade constraints;
drop TABLE CCBADM.CI_MD_ATT_TY cascade constraints;
drop TABLE CCBADM.CI_MD_AT_DTL cascade constraints;
drop TABLE CCBADM.CI_MD_AT_DTL_L cascade constraints;
drop TABLE CCBADM.CI_MD_CONST cascade constraints;
drop TABLE CCBADM.CI_MD_CONST_FLD cascade constraints;
drop TABLE CCBADM.CI_MD_CTL cascade constraints;
drop TABLE CCBADM.CI_MD_CTL_L cascade constraints;
drop TABLE CCBADM.CI_MD_CTL_TMPL cascade constraints;
drop TABLE CCBADM.CI_MD_ELTY cascade constraints;
drop TABLE CCBADM.CI_MD_ELTY_AT cascade constraints;
drop TABLE CCBADM.CI_MD_ELTY_L cascade constraints;
drop TABLE CCBADM.CI_MD_FLD cascade constraints;
drop TABLE CCBADM.CI_MD_FLD_L cascade constraints;
drop TABLE CCBADM.CI_MD_LOOKUP_F cascade constraints;
drop TABLE CCBADM.CI_MD_MENU cascade constraints;
drop TABLE CCBADM.CI_MD_MENU_IMOD cascade constraints;
drop TABLE CCBADM.CI_MD_MENU_ITEM cascade constraints;
drop TABLE CCBADM.CI_MD_MENU_ITEM_L cascade constraints;
drop TABLE CCBADM.CI_MD_MENU_L cascade constraints;
drop TABLE CCBADM.CI_MD_MENU_LINE cascade constraints;
drop TABLE CCBADM.CI_MD_MENU_LINE_L cascade constraints;
drop TABLE CCBADM.CI_MD_MENU_MOD cascade constraints;
drop TABLE CCBADM.CI_MD_MO cascade constraints;
drop TABLE CCBADM.CI_MD_MO_ALG cascade constraints;
drop TABLE CCBADM.CI_MD_MO_L cascade constraints;
drop TABLE CCBADM.CI_MD_MO_OPT cascade constraints;
drop TABLE CCBADM.CI_MD_MO_TBL cascade constraints;
drop TABLE CCBADM.CI_MD_MO_WRK cascade constraints;
drop TABLE CCBADM.CI_MD_MSG cascade constraints;
drop TABLE CCBADM.CI_MD_MSG_L cascade constraints;
drop TABLE CCBADM.CI_MD_NAV cascade constraints;
drop TABLE CCBADM.CI_MD_PDF cascade constraints;
drop TABLE CCBADM.CI_MD_PDF_VAL cascade constraints;
drop TABLE CCBADM.CI_MD_PRG_COM cascade constraints;
drop TABLE CCBADM.CI_MD_PRG_ELEM cascade constraints;
drop TABLE CCBADM.CI_MD_PRG_EL_AT cascade constraints;
drop TABLE CCBADM.CI_MD_PRG_LOC cascade constraints;
drop TABLE CCBADM.CI_MD_PRG_MOD cascade constraints;
drop TABLE CCBADM.CI_MD_PRG_SEC cascade constraints;
drop TABLE CCBADM.CI_MD_PRG_SQL cascade constraints;
drop TABLE CCBADM.CI_MD_PRG_TAB cascade constraints;
drop TABLE CCBADM.CI_MD_PRG_VAR cascade constraints;
drop TABLE CCBADM.CI_MD_RPT cascade constraints;
drop TABLE CCBADM.CI_MD_RPT_L cascade constraints;
drop TABLE CCBADM.CI_MD_RPT_LBL cascade constraints;
drop TABLE CCBADM.CI_MD_RPT_PARM cascade constraints;
drop TABLE CCBADM.CI_MD_RPT_PARM_L cascade constraints;
drop TABLE CCBADM.CI_MD_SO cascade constraints;
drop TABLE CCBADM.CI_MD_SOCG cascade constraints;
drop TABLE CCBADM.CI_MD_SOCG_FLD cascade constraints;
drop TABLE CCBADM.CI_MD_SOCG_FLDAT cascade constraints;
drop TABLE CCBADM.CI_MD_SOCG_L cascade constraints;
drop TABLE CCBADM.CI_MD_SOCG_SORT cascade constraints;
drop TABLE CCBADM.CI_MD_SO_L cascade constraints;
drop TABLE CCBADM.CI_MD_SO_RSFLD cascade constraints;
drop TABLE CCBADM.CI_MD_SO_RSFLDAT cascade constraints;
drop TABLE CCBADM.CI_MD_SRC_TYPE cascade constraints;
drop TABLE CCBADM.CI_MD_SRC_TYPE_L cascade constraints;
drop TABLE CCBADM.CI_MD_SVC cascade constraints;
drop TABLE CCBADM.CI_MD_SVC_L cascade constraints;
drop TABLE CCBADM.CI_MD_SVC_PRG cascade constraints;
drop TABLE CCBADM.CI_MD_TAB_MOD cascade constraints;
drop TABLE CCBADM.CI_MD_TBL_FLD cascade constraints;
drop TABLE CCBADM.CI_MD_TBL_FLD_L cascade constraints;
drop TABLE CCBADM.CI_MD_TBL_L cascade constraints;
drop TABLE CCBADM.CI_MD_TMPL cascade constraints;
drop TABLE CCBADM.CI_MD_TMPL_ELTY cascade constraints;
drop TABLE CCBADM.CI_MD_TMPL_L cascade constraints;
drop TABLE CCBADM.CI_MD_TMPL_VAR cascade constraints;
drop TABLE CCBADM.CI_MD_TMPL_VAR_L cascade constraints;
drop TABLE CCBADM.CI_MD_TOOLREP_XML cascade constraints;
drop TABLE CCBADM.CI_MD_TOOL_REP cascade constraints;
drop TABLE CCBADM.CI_MD_VAR cascade constraints;
drop TABLE CCBADM.CI_MD_VAR_DTL cascade constraints;
drop TABLE CCBADM.CI_MD_VAR_DTL_L cascade constraints;
drop TABLE CCBADM.CI_MD_WRK_TBL cascade constraints;
drop TABLE CCBADM.CI_MD_WRK_TBLFLD cascade constraints;
drop TABLE CCBADM.CI_MD_WRK_TBL_L cascade constraints;
drop TABLE CCBADM.CI_MSG cascade constraints;
drop TABLE CCBADM.CI_MSG_CATEGORY cascade constraints;
drop TABLE CCBADM.CI_MSG_CATEGORY_L cascade constraints;
drop TABLE CCBADM.CI_MSG_L cascade constraints;
drop TABLE CCBADM.CI_MSG_LOG cascade constraints;
drop TABLE CCBADM.CI_MSG_LOGPARM cascade constraints;
drop TABLE CCBADM.CI_MSG_LOG_PK cascade constraints;
drop TABLE CCBADM.CI_NAV_OPT cascade constraints;
drop TABLE CCBADM.CI_NAV_OPT_CTXT cascade constraints;
drop TABLE CCBADM.CI_NAV_OPT_L cascade constraints;
drop TABLE CCBADM.CI_NAV_OPT_USG cascade constraints;
drop TABLE CCBADM.CI_NT_DNTY_CTXT cascade constraints;
drop TABLE CCBADM.CI_NT_DWN cascade constraints;
drop TABLE CCBADM.CI_NT_DWN_CHAR cascade constraints;
drop TABLE CCBADM.CI_NT_DWN_CTXT cascade constraints;
drop TABLE CCBADM.CI_NT_DWN_EXC cascade constraints;
drop TABLE CCBADM.CI_NT_DWN_EXP cascade constraints;
drop TABLE CCBADM.CI_NT_DWN_FORM cascade constraints;
drop TABLE CCBADM.CI_NT_DWN_FORM_L cascade constraints;
drop TABLE CCBADM.CI_NT_DWN_PROF cascade constraints;
drop TABLE CCBADM.CI_NT_DWN_PROF_L cascade constraints;
drop TABLE CCBADM.CI_NT_DWN_TYPE cascade constraints;
drop TABLE CCBADM.CI_NT_DWN_TYPE_L cascade constraints;
drop TABLE CCBADM.CI_NT_UP cascade constraints;
drop TABLE CCBADM.CI_NT_UP_CHAR cascade constraints;
drop TABLE CCBADM.CI_NT_UP_CTXT cascade constraints;
drop TABLE CCBADM.CI_NT_UP_EXCP cascade constraints;
drop TABLE CCBADM.CI_NT_UP_XTYPE cascade constraints;
drop TABLE CCBADM.CI_NT_UP_XTYPE_L cascade constraints;
drop TABLE CCBADM.CI_NT_XID cascade constraints;
drop TABLE CCBADM.CI_NT_XID_L cascade constraints;
drop TABLE CCBADM.CI_PHONE_TYPE cascade constraints;
drop TABLE CCBADM.CI_PHONE_TYPE_L cascade constraints;
drop TABLE CCBADM.CI_PORTAL cascade constraints;
drop TABLE CCBADM.CI_PORTAL_L cascade constraints;
drop TABLE CCBADM.CI_PORTAL_ZONE cascade constraints;
drop TABLE CCBADM.CI_ROLE cascade constraints;
drop TABLE CCBADM.CI_ROLE_L cascade constraints;
drop TABLE CCBADM.CI_ROLE_USER cascade constraints;
drop TABLE CCBADM.CI_ROOT_DIFF cascade constraints;
drop TABLE CCBADM.CI_ROOT_INSTR cascade constraints;
drop TABLE CCBADM.CI_ROOT_OBJ cascade constraints;
drop TABLE CCBADM.CI_ROOT_OBJ_EXC cascade constraints;
drop TABLE CCBADM.CI_ROOT_OBJ_EXP cascade constraints;
drop TABLE CCBADM.CI_ROOT_OBJ_PK cascade constraints;
drop TABLE CCBADM.CI_RPT_OPTION cascade constraints;
drop TABLE CCBADM.CI_SCR cascade constraints;
drop TABLE CCBADM.CI_SCR_CRT cascade constraints;
drop TABLE CCBADM.CI_SCR_CRT_GRP cascade constraints;
drop TABLE CCBADM.CI_SCR_CRT_GRP_L cascade constraints;
drop TABLE CCBADM.CI_SCR_DA cascade constraints;
drop TABLE CCBADM.CI_SCR_FLD_MAP cascade constraints;
drop TABLE CCBADM.CI_SCR_L cascade constraints;
drop TABLE CCBADM.CI_SCR_PRMPT cascade constraints;
drop TABLE CCBADM.CI_SCR_PRMPT_L cascade constraints;
drop TABLE CCBADM.CI_SCR_STEP_L cascade constraints;
drop TABLE CCBADM.CI_SC_AUTH_LVL cascade constraints;
drop TABLE CCBADM.CI_SC_AUTH_LVL_L cascade constraints;
drop TABLE CCBADM.CI_SC_TYPE cascade constraints;
drop TABLE CCBADM.CI_SC_TYPE_L cascade constraints;
drop TABLE CCBADM.CI_SEAS_SHIFT cascade constraints;
drop TABLE CCBADM.CI_SEAS_TM_SHIFT cascade constraints;
drop TABLE CCBADM.CI_SEAS_TM_SHIFT_L cascade constraints;
drop TABLE CCBADM.CI_SEQ cascade constraints;
drop TABLE CCBADM.CI_STATE cascade constraints;
drop TABLE CCBADM.CI_STATE_L cascade constraints;
drop TABLE CCBADM.CI_SYSDATA_LOG cascade constraints;
drop TABLE CCBADM.CI_TD_DRLKEY cascade constraints;
drop TABLE CCBADM.CI_TD_DRLKEY_TY cascade constraints;
drop TABLE CCBADM.CI_TD_ENTRY cascade constraints;
drop TABLE CCBADM.CI_TD_ENTRY_CHA cascade constraints;
drop TABLE CCBADM.CI_TD_EX_LIST cascade constraints;
drop TABLE CCBADM.CI_TD_LOG cascade constraints;
drop TABLE CCBADM.CI_TD_MSG_PARM cascade constraints;
drop TABLE CCBADM.CI_TD_SRTKEY cascade constraints;
drop TABLE CCBADM.CI_TD_SRTKEY_TY cascade constraints;
drop TABLE CCBADM.CI_TD_SRTKEY_TY_L cascade constraints;
drop TABLE CCBADM.CI_TD_TYPE cascade constraints;
drop TABLE CCBADM.CI_TD_TYPE_ALG cascade constraints;
drop TABLE CCBADM.CI_TD_TYPE_CHAR cascade constraints;
drop TABLE CCBADM.CI_TD_TYPE_L cascade constraints;
drop TABLE CCBADM.CI_TD_VAL_ROLE cascade constraints;
drop TABLE CCBADM.CI_TIME_ZONE cascade constraints;
drop TABLE CCBADM.CI_TIME_ZONE_L cascade constraints;
drop TABLE CCBADM.CI_UI_ZONE cascade constraints;
drop TABLE CCBADM.CI_USR_GRP_SC cascade constraints;
drop TABLE CCBADM.CI_USR_NAV_LINK cascade constraints;
drop TABLE CCBADM.CI_USR_PORTAL cascade constraints;
drop TABLE CCBADM.CI_USR_SCR cascade constraints;
drop TABLE CCBADM.CI_VAL_ERR cascade constraints;
drop TABLE CCBADM.CI_VAL_FK_ERR cascade constraints;
drop TABLE CCBADM.CI_WFM cascade constraints;
drop TABLE CCBADM.CI_WFM_L cascade constraints;
drop TABLE CCBADM.CI_WFM_MSG cascade constraints;
drop TABLE CCBADM.CI_WFM_OPT cascade constraints;
drop TABLE CCBADM.CI_WF_EVT cascade constraints;
drop TABLE CCBADM.CI_WF_EVT_CHAR cascade constraints;
drop TABLE CCBADM.CI_WF_EVT_CTXT cascade constraints;
drop TABLE CCBADM.CI_WF_EVT_DEP cascade constraints;
drop TABLE CCBADM.CI_WF_EVT_EXC cascade constraints;
drop TABLE CCBADM.CI_WF_EVT_EXP cascade constraints;
drop TABLE CCBADM.CI_WF_EVT_TYPE cascade constraints;
drop TABLE CCBADM.CI_WF_EVT_TYPE_L cascade constraints;
drop TABLE CCBADM.CI_WF_PP cascade constraints;
drop TABLE CCBADM.CI_WF_PP_L cascade constraints;
drop TABLE CCBADM.CI_WF_PP_NT cascade constraints;
drop TABLE CCBADM.CI_WF_PP_NT_CRT cascade constraints;
drop TABLE CCBADM.CI_WF_PROC cascade constraints;
drop TABLE CCBADM.CI_WF_PROC_CHAR cascade constraints;
drop TABLE CCBADM.CI_WF_PROC_CTXT cascade constraints;
drop TABLE CCBADM.CI_WF_PROC_MSGP cascade constraints;
drop TABLE CCBADM.CI_WF_PROC_SCHED cascade constraints;
drop TABLE CCBADM.CI_WF_PROC_TMPL cascade constraints;
drop TABLE CCBADM.CI_WF_PROC_TMPL_L cascade constraints;
drop TABLE CCBADM.CI_WF_RESP cascade constraints;
drop TABLE CCBADM.CI_WF_RESP_DEP cascade constraints;
drop TABLE CCBADM.CI_XAI_ADAPTER cascade constraints;
drop TABLE CCBADM.CI_XAI_ADAPTER_L cascade constraints;
drop TABLE CCBADM.CI_XAI_CLASS cascade constraints;
drop TABLE CCBADM.CI_XAI_CLASS_L cascade constraints;
drop TABLE CCBADM.CI_XAI_DWN_EXC cascade constraints;
drop TABLE CCBADM.CI_XAI_DWN_EXP cascade constraints;
drop TABLE CCBADM.CI_XAI_ENV_HNDL cascade constraints;
drop TABLE CCBADM.CI_XAI_ENV_HNDL_L cascade constraints;
drop TABLE CCBADM.CI_XAI_EXECUTER cascade constraints;
drop TABLE CCBADM.CI_XAI_EXECUTER_L cascade constraints;
drop TABLE CCBADM.CI_XAI_FORMAT cascade constraints;
drop TABLE CCBADM.CI_XAI_FORMAT_L cascade constraints;
drop TABLE CCBADM.CI_XAI_IN_SVC cascade constraints;
drop TABLE CCBADM.CI_XAI_IN_SVC_L cascade constraints;
drop TABLE CCBADM.CI_XAI_JDBC_CON cascade constraints;
drop TABLE CCBADM.CI_XAI_JDBC_CON_L cascade constraints;
drop TABLE CCBADM.CI_XAI_JMS_CON cascade constraints;
drop TABLE CCBADM.CI_XAI_JMS_CON_L cascade constraints;
drop TABLE CCBADM.CI_XAI_JMS_Q cascade constraints;
drop TABLE CCBADM.CI_XAI_JMS_Q_L cascade constraints;
drop TABLE CCBADM.CI_XAI_JMS_TPC cascade constraints;
drop TABLE CCBADM.CI_XAI_JMS_TPC_L cascade constraints;
drop TABLE CCBADM.CI_XAI_JNDI_SVR cascade constraints;
drop TABLE CCBADM.CI_XAI_JNDI_SVR_L cascade constraints;
drop TABLE CCBADM.CI_XAI_OPTION cascade constraints;
drop TABLE CCBADM.CI_XAI_RCVR cascade constraints;
drop TABLE CCBADM.CI_XAI_RCVR_CTX cascade constraints;
drop TABLE CCBADM.CI_XAI_RCVR_L cascade constraints;
drop TABLE CCBADM.CI_XAI_RCVR_RGRP cascade constraints;
drop TABLE CCBADM.CI_XAI_RCVR_RSP cascade constraints;
drop TABLE CCBADM.CI_XAI_RGRP cascade constraints;
drop TABLE CCBADM.CI_XAI_RGRP_ATT cascade constraints;
drop TABLE CCBADM.CI_XAI_RGRP_L cascade constraints;
drop TABLE CCBADM.CI_XAI_ROUTING cascade constraints;
drop TABLE CCBADM.CI_XAI_RT_TYPE cascade constraints;
drop TABLE CCBADM.CI_XAI_RT_TYPE_L cascade constraints;
drop TABLE CCBADM.CI_XAI_RULE cascade constraints;
drop TABLE CCBADM.CI_XAI_SENDER cascade constraints;
drop TABLE CCBADM.CI_XAI_SENDER_L cascade constraints;
drop TABLE CCBADM.CI_XAI_SNDR_CTX cascade constraints;
drop TABLE CCBADM.CI_XAI_SVC_PARM cascade constraints;
drop TABLE CCBADM.CI_XML_STGCTL_P cascade constraints;
drop TABLE CCBADM.CI_XML_STGUPEXP cascade constraints;
drop TABLE CCBADM.CI_XML_STGUP_EX cascade constraints;
drop TABLE CCBADM.CI_XML_STG_CTL cascade constraints;
drop TABLE CCBADM.CI_ZONE cascade constraints;
drop TABLE CCBADM.CI_ZONE_HDL cascade constraints;
drop TABLE CCBADM.CI_ZONE_HDL_L cascade constraints;
drop TABLE CCBADM.CI_ZONE_HDL_PRM cascade constraints;
drop TABLE CCBADM.CI_ZONE_HDL_PRM_L cascade constraints;
drop TABLE CCBADM.CI_ZONE_L cascade constraints;
drop TABLE CCBADM.CI_ZONE_PRM cascade constraints;
drop TABLE CCBADM.F1_ATTACHMENT_CHAR cascade constraints;
drop TABLE CCBADM.F1_BNDL_CHAR cascade constraints;
drop TABLE CCBADM.F1_BNDL_ENTITY cascade constraints;
drop TABLE CCBADM.F1_BNDL_LOG cascade constraints;
drop TABLE CCBADM.F1_BNDL_LOG_PARM cascade constraints;
drop TABLE CCBADM.F1_BUS_EVT_LOG_CHAR cascade constraints;
drop TABLE CCBADM.F1_BUS_EVT_LOG_MSG_PARM cascade constraints;
drop TABLE CCBADM.F1_BUS_OBJ cascade constraints;
drop TABLE CCBADM.F1_BUS_OBJ_ALG cascade constraints;
drop TABLE CCBADM.F1_BUS_OBJ_L cascade constraints;
drop TABLE CCBADM.F1_BUS_OBJ_OPT cascade constraints;
drop TABLE CCBADM.F1_BUS_OBJ_STATUS cascade constraints;
drop TABLE CCBADM.F1_BUS_OBJ_STATUS_ALG cascade constraints;
drop TABLE CCBADM.F1_BUS_OBJ_STATUS_L cascade constraints;
drop TABLE CCBADM.F1_BUS_OBJ_STATUS_OPT cascade constraints;
drop TABLE CCBADM.F1_BUS_OBJ_STATUS_RSN_CHAR cascade constraints;
drop TABLE CCBADM.F1_BUS_OBJ_STATUS_RSN_L cascade constraints;
drop TABLE CCBADM.F1_BUS_OBJ_TR_RULE cascade constraints;
drop TABLE CCBADM.F1_BUS_OBJ_TR_RULE_L cascade constraints;
drop TABLE CCBADM.F1_BUS_SVC cascade constraints;
drop TABLE CCBADM.F1_BUS_SVC_L cascade constraints;
drop TABLE CCBADM.F1_DATA_AREA cascade constraints;
drop TABLE CCBADM.F1_DATA_AREA_L cascade constraints;
drop TABLE CCBADM.F1_DB_OBJECTS_REPO cascade constraints;
drop TABLE CCBADM.F1_EXTSYS_OUTMSG_PROF cascade constraints;
drop TABLE CCBADM.F1_EXT_LOOKUP_VAL_L cascade constraints;
drop TABLE CCBADM.F1_FACT_CHAR cascade constraints;
drop TABLE CCBADM.F1_FACT_LOG cascade constraints;
drop TABLE CCBADM.F1_FACT_LOG_PARM cascade constraints;
drop TABLE CCBADM.F1_GEN_PROC cascade constraints;
drop TABLE CCBADM.F1_INSTALLATION cascade constraints;
drop TABLE CCBADM.F1_MANAG_CONTENT_L cascade constraints;
drop TABLE CCBADM.F1_MAP_L cascade constraints;
drop TABLE CCBADM.F1_MD_DB_OBJ cascade constraints;
drop TABLE CCBADM.F1_MIGR_DATA_ST cascade constraints;
drop TABLE CCBADM.F1_MIGR_DATA_ST_ALG cascade constraints;
drop TABLE CCBADM.F1_MIGR_DATA_ST_LOG cascade constraints;
drop TABLE CCBADM.F1_MIGR_DATA_ST_LOG_PARM cascade constraints;
drop TABLE CCBADM.F1_MIGR_OBJ_ALG cascade constraints;
drop TABLE CCBADM.F1_MIGR_OBJ_LOG cascade constraints;
drop TABLE CCBADM.F1_MIGR_OBJ_LOG_PARM cascade constraints;
drop TABLE CCBADM.F1_MIGR_OBJ_SQL cascade constraints;
drop TABLE CCBADM.F1_MIGR_PLAN cascade constraints;
drop TABLE CCBADM.F1_MIGR_PLAN_INSTR cascade constraints;
drop TABLE CCBADM.F1_MIGR_PLAN_INSTR_ALG cascade constraints;
drop TABLE CCBADM.F1_MIGR_PLAN_INSTR_L cascade constraints;
drop TABLE CCBADM.F1_MIGR_PLAN_L cascade constraints;
drop TABLE CCBADM.F1_MIGR_REQ cascade constraints;
drop TABLE CCBADM.F1_MIGR_REQ_INSTR cascade constraints;
drop TABLE CCBADM.F1_MIGR_REQ_INSTR_ENTITY cascade constraints;
drop TABLE CCBADM.F1_MIGR_REQ_INSTR_L cascade constraints;
drop TABLE CCBADM.F1_MIGR_REQ_L cascade constraints;
drop TABLE CCBADM.F1_MIGR_TRANS cascade constraints;
drop TABLE CCBADM.F1_MIGR_TRANS_LOG cascade constraints;
drop TABLE CCBADM.F1_MIGR_TRANS_LOG_PARM cascade constraints;
drop TABLE CCBADM.F1_OBJ_REV_CHAR cascade constraints;
drop TABLE CCBADM.F1_OBJ_REV_LOG cascade constraints;
drop TABLE CCBADM.F1_OBJ_REV_LOG_PARM cascade constraints;
drop TABLE CCBADM.F1_OUTMSG_ERRPARM cascade constraints;
drop TABLE CCBADM.F1_OUTMSG_TYPE cascade constraints;
drop TABLE CCBADM.F1_OUTMSG_TYPE_L cascade constraints;
drop TABLE CCBADM.F1_REQ_LOG cascade constraints;
drop TABLE CCBADM.F1_REQ_LOG_PARM cascade constraints;
drop TABLE CCBADM.F1_REQ_TYPE_L cascade constraints;
drop TABLE CCBADM.F1_REQ_TYPE_LOG cascade constraints;
drop TABLE CCBADM.F1_REQ_TYPE_LOG_PARM cascade constraints;
drop TABLE CCBADM.F1_SVC_TASK_CHAR cascade constraints;
drop TABLE CCBADM.F1_SVC_TASK_LOG cascade constraints;
drop TABLE CCBADM.F1_SVC_TASK_LOG_PARM cascade constraints;
drop TABLE CCBADM.F1_SVC_TASK_REL_OBJ cascade constraints;
drop TABLE CCBADM.F1_SVC_TASK_TYPE_CHAR cascade constraints;
drop TABLE CCBADM.F1_SVC_TASK_TYPE_L cascade constraints;
drop TABLE CCBADM.F1_SYNC_REQ_CHAR cascade constraints;
drop TABLE CCBADM.F1_SYNC_REQ_EXTRACT cascade constraints;
drop TABLE CCBADM.F1_SYNC_REQ_IN_CHAR cascade constraints;
drop TABLE CCBADM.F1_SYNC_REQ_IN_EXCP cascade constraints;
drop TABLE CCBADM.F1_SYNC_REQ_IN_EXCP_PARM cascade constraints;
drop TABLE CCBADM.F1_SYNC_REQ_IN_LOG cascade constraints;
drop TABLE CCBADM.F1_SYNC_REQ_IN_LOG_PARM cascade constraints;
drop TABLE CCBADM.F1_SYNC_REQ_IN_REL_OBJ cascade constraints;
drop TABLE CCBADM.F1_SYNC_REQ_LOG cascade constraints;
drop TABLE CCBADM.F1_SYNC_REQ_LOG_PARM cascade constraints;
drop TABLE CCBADM.F1_WEB_SVC_CHAR cascade constraints;
drop TABLE CCBADM.F1_WEB_SVC_L cascade constraints;
drop TABLE CCBADM.F1_WEB_SVC_LOG cascade constraints;
drop TABLE CCBADM.F1_WEB_SVC_LOG_PARM cascade constraints;
drop TABLE CCBADM.F1_WEB_SVC_OPERATIONS cascade constraints;
drop TABLE CCBADM.SC_ACCESS_CNTL cascade constraints;
drop TABLE CCBADM.SC_APP_SERVICE cascade constraints;
drop TABLE CCBADM.SC_APP_SERVICE_L cascade constraints;
drop TABLE CCBADM.SC_USER cascade constraints;
drop TABLE CCBADM.SC_USER_CHAR cascade constraints;
drop TABLE CCBADM.SC_USER_GROUP cascade constraints;
drop TABLE CCBADM.SC_USER_GROUP_L cascade constraints;
drop TABLE CCBADM.SC_USR_GRP_PROF cascade constraints;
drop TABLE CCBADM.SC_USR_GRP_USR cascade constraints;
drop TABLE CCBADM.C0_INSTALLATION cascade constraints;
drop TABLE CCBADM.C1_CALC_GRP_CHAR cascade constraints;
drop TABLE CCBADM.C1_CALC_GRP_L cascade constraints;
drop TABLE CCBADM.C1_CALC_RULE_CHAR cascade constraints;
drop TABLE CCBADM.C1_CALC_RULE_CRT_CHAR cascade constraints;
drop TABLE CCBADM.C1_CALC_RULE_CRT_L cascade constraints;
drop TABLE CCBADM.C1_CALC_RULE_L cascade constraints;
drop TABLE CCBADM.C1_CALC_RULE_MBR_CAT cascade constraints;
drop TABLE CCBADM.C1_CALC_RULE_TRGT_CAT cascade constraints;
drop TABLE CCBADM.C1_CL_CAT_TYPE_CHAR cascade constraints;
drop TABLE CCBADM.C1_CL_CAT_TYPE_L cascade constraints;
drop TABLE CCBADM.C1_CL_CAT_VAL cascade constraints;
drop TABLE CCBADM.C1_CL_CAT_VAL_L cascade constraints;
drop TABLE CCBADM.C1_INITIATIVE_CHAR cascade constraints;
drop TABLE CCBADM.C1_INITIATIVE_L cascade constraints;
drop TABLE CCBADM.C1_INITIATIVE_LEAD_CRIT_CHAR cascade constraints;
drop TABLE CCBADM.C1_INITIATIVE_LEAD_CRIT_L cascade constraints;
drop TABLE CCBADM.C1_INITIATIVE_LEAD_DEFN cascade constraints;
drop TABLE CCBADM.C1_INITIATIVE_LOG cascade constraints;
drop TABLE CCBADM.C1_INITIATIVE_LOG_PARM cascade constraints;
drop TABLE CCBADM.C1_INITIATIVE_PRTC_CRIT_CHAR cascade constraints;
drop TABLE CCBADM.C1_INITIATIVE_PRTC_CRIT_L cascade constraints;
drop TABLE CCBADM.C1_ISS_CTR_CHAR cascade constraints;
drop TABLE CCBADM.C1_ISS_CTR_DTL cascade constraints;
drop TABLE CCBADM.C1_ISS_CTR_L cascade constraints;
drop TABLE CCBADM.C1_ISS_CTR_LOG cascade constraints;
drop TABLE CCBADM.C1_ISS_CTR_LOG_PARM cascade constraints;
drop TABLE CCBADM.C1_LEAD_CHAR cascade constraints;
drop TABLE CCBADM.C1_LEAD_EVT_CHAR cascade constraints;
drop TABLE CCBADM.C1_LEAD_EVT_LOG cascade constraints;
drop TABLE CCBADM.C1_LEAD_EVT_LOG_PARM cascade constraints;
drop TABLE CCBADM.C1_LEAD_EVT_TYPE_CHAR cascade constraints;
drop TABLE CCBADM.C1_LEAD_EVT_TYPE_L cascade constraints;
drop TABLE CCBADM.C1_LEAD_LOG cascade constraints;
drop TABLE CCBADM.C1_LEAD_LOG_PARM cascade constraints;
drop TABLE CCBADM.C1_LEAD_REL_OBJ cascade constraints;
drop TABLE CCBADM.C1_OFFCYC_BGEN_ADJ cascade constraints;
drop TABLE CCBADM.C1_OFFCYC_BGEN_BCHG cascade constraints;
drop TABLE CCBADM.C1_OFFCYC_BGEN_CHAR cascade constraints;
drop TABLE CCBADM.C1_OFFCYC_BGEN_LOG cascade constraints;
drop TABLE CCBADM.C1_OFFCYC_BGEN_LOG_PARM cascade constraints;
drop TABLE CCBADM.C1_OFFCYC_BGEN_SA cascade constraints;
drop TABLE CCBADM.C1_RS_POST_PROC cascade constraints;
drop TABLE CCBADM.C1_RS_POST_PROC_L cascade constraints;
drop TABLE CCBADM.C1_RS_PRE_PROC cascade constraints;
drop TABLE CCBADM.C1_RS_PRE_PROC_L cascade constraints;
drop TABLE CCBADM.C1_RS_RV2 cascade constraints;
drop TABLE CCBADM.C1_RS_RV2_L cascade constraints;
drop TABLE CCBADM.C1_TOU_MAP_CHAR cascade constraints;
drop TABLE CCBADM.C1_TOU_MAP_DATA cascade constraints;
drop TABLE CCBADM.C1_TOU_MAP_DATA_CHAR cascade constraints;
drop TABLE CCBADM.C1_TOU_MAP_L cascade constraints;
drop TABLE CCBADM.C1_TOU_MAP_LOG cascade constraints;
drop TABLE CCBADM.C1_TOU_MAP_LOG_PARM cascade constraints;
drop TABLE CCBADM.C1_TOU_MAP_TMPLT_CHAR cascade constraints;
drop TABLE CCBADM.C1_TOU_MAP_TMPLT_L cascade constraints;
drop TABLE CCBADM.C1_TOU_MAP_TYPE_CHAR cascade constraints;
drop TABLE CCBADM.C1_TOU_MAP_TYPE_L cascade constraints;
drop TABLE CCBADM.C1_TOU_MAP_TYPE_TMPLT cascade constraints;
drop TABLE CCBADM.C1_USAGE_CHAR cascade constraints;
drop TABLE CCBADM.C1_USAGE_LOG cascade constraints;
drop TABLE CCBADM.C1_USAGE_LOG_PARM cascade constraints;
drop TABLE CCBADM.C1_USER_TNDR_SRCE cascade constraints;
drop TABLE CCBADM.CI_ACCT_ALERT cascade constraints;
drop TABLE CCBADM.CI_ACCT_APAY cascade constraints;
drop TABLE CCBADM.CI_ACCT_CHAR cascade constraints;
drop TABLE CCBADM.CI_ACCT_MGMT_GR cascade constraints;
drop TABLE CCBADM.CI_ACCT_MGMT_GR_L cascade constraints;
drop TABLE CCBADM.CI_ACCT_MGRP_RL cascade constraints;
drop TABLE CCBADM.CI_ACCT_MSG cascade constraints;
drop TABLE CCBADM.CI_ACCT_MSG_PRM cascade constraints;
drop TABLE CCBADM.CI_ACCT_PER cascade constraints;
drop TABLE CCBADM.CI_ACCT_REL_TYP cascade constraints;
drop TABLE CCBADM.CI_ACCT_REL_TYP_L cascade constraints;
drop TABLE CCBADM.CI_ACCT_STG cascade constraints;
drop TABLE CCBADM.CI_ADJT_ADJTPRF cascade constraints;
drop TABLE CCBADM.CI_ADJ_APREQ cascade constraints;
drop TABLE CCBADM.CI_ADJ_CALC_LN cascade constraints;
drop TABLE CCBADM.CI_ADJ_CAN_RSN cascade constraints;
drop TABLE CCBADM.CI_ADJ_CAN_RSN_L cascade constraints;
drop TABLE CCBADM.CI_ADJ_CHAR cascade constraints;
drop TABLE CCBADM.CI_ADJ_CL_CHAR cascade constraints;
drop TABLE CCBADM.CI_ADJ_STG_CTL cascade constraints;
drop TABLE CCBADM.CI_ADJ_STG_CTL_CHAR cascade constraints;
drop TABLE CCBADM.CI_ADJ_STG_CTL_MSGP cascade constraints;
drop TABLE CCBADM.CI_ADJ_STG_UP cascade constraints;
drop TABLE CCBADM.CI_ADJ_STG_UP_CHAR cascade constraints;
drop TABLE CCBADM.CI_ADJ_STG_UP_MSGP cascade constraints;
drop TABLE CCBADM.CI_ADJ_TYPE cascade constraints;
drop TABLE CCBADM.CI_ADJ_TYPE_L cascade constraints;
drop TABLE CCBADM.CI_ADJ_TYP_PROF cascade constraints;
drop TABLE CCBADM.CI_ADJ_TYP_PROF_L cascade constraints;
drop TABLE CCBADM.CI_ADJ_TY_ALG cascade constraints;
drop TABLE CCBADM.CI_ADJ_TY_CHAR cascade constraints;
drop TABLE CCBADM.CI_ADM_RVW_SCH cascade constraints;
drop TABLE CCBADM.CI_ALERT_TYPE cascade constraints;
drop TABLE CCBADM.CI_ALERT_TYPE_L cascade constraints;
drop TABLE CCBADM.CI_AM_ACTIVITY_TYPE_L cascade constraints;
drop TABLE CCBADM.CI_AM_REQ_LOG cascade constraints;
drop TABLE CCBADM.CI_AM_REQ_LOG_PARM cascade constraints;
drop TABLE CCBADM.CI_APAY_CLR_STG cascade constraints;
drop TABLE CCBADM.CI_APAY_RT_TYPE cascade constraints;
drop TABLE CCBADM.CI_APAY_RT_TYPE_L cascade constraints;
drop TABLE CCBADM.CI_APAY_SRC cascade constraints;
drop TABLE CCBADM.CI_APAY_SRC_L cascade constraints;
drop TABLE CCBADM.CI_APPR_PROF_L cascade constraints;
drop TABLE CCBADM.CI_APPR_REQ_CHAR cascade constraints;
drop TABLE CCBADM.CI_APPR_REQ_LOG cascade constraints;
drop TABLE CCBADM.CI_APPR_REQ_LOG_PARM cascade constraints;
drop TABLE CCBADM.CI_APREQ_TYPE cascade constraints;
drop TABLE CCBADM.CI_APREQ_TYPE_L cascade constraints;
drop TABLE CCBADM.CI_BAL_CTL_GRP cascade constraints;
drop TABLE CCBADM.CI_BAL_CTL_MEM cascade constraints;
drop TABLE CCBADM.CI_BAL_CTL_TMP cascade constraints;
drop TABLE CCBADM.CI_BANK cascade constraints;
drop TABLE CCBADM.CI_BANK_ACCOUNT cascade constraints;
drop TABLE CCBADM.CI_BANK_ACCOUNT_L cascade constraints;
drop TABLE CCBADM.CI_BANK_L cascade constraints;
drop TABLE CCBADM.CI_BCHG_LINE_UP cascade constraints;
drop TABLE CCBADM.CI_BCHG_READ cascade constraints;
drop TABLE CCBADM.CI_BCHG_SQ cascade constraints;
drop TABLE CCBADM.CI_BCHG_UP cascade constraints;
drop TABLE CCBADM.CI_BCHG_UP_EXCP cascade constraints;
drop TABLE CCBADM.CI_BCHG_UP_OVRD cascade constraints;
drop TABLE CCBADM.CI_BCHG_UP_READ cascade constraints;
drop TABLE CCBADM.CI_BCHG_UP_SQ cascade constraints;
drop TABLE CCBADM.CI_BCHG_UP_XTYP cascade constraints;
drop TABLE CCBADM.CI_BCHG_UP_XTYP_L cascade constraints;
drop TABLE CCBADM.CI_BF cascade constraints;
drop TABLE CCBADM.CI_BFCH_TOUGRP cascade constraints;
drop TABLE CCBADM.CI_BF_CHAR cascade constraints;
drop TABLE CCBADM.CI_BF_CHAR_DST cascade constraints;
drop TABLE CCBADM.CI_BF_L cascade constraints;
drop TABLE CCBADM.CI_BF_VAL cascade constraints;
drop TABLE CCBADM.CI_BILL cascade constraints;
drop TABLE CCBADM.CI_BILL_CAN_RSN cascade constraints;
drop TABLE CCBADM.CI_BILL_CAN_RSN_L cascade constraints;
drop TABLE CCBADM.CI_BILL_CHAR cascade constraints;
drop TABLE CCBADM.CI_BILL_CHG cascade constraints;
drop TABLE CCBADM.CI_BILL_CYC cascade constraints;
drop TABLE CCBADM.CI_BILL_CYC_L cascade constraints;
drop TABLE CCBADM.CI_BILL_CYC_SCH cascade constraints;
drop TABLE CCBADM.CI_BILL_EXCP cascade constraints;
drop TABLE CCBADM.CI_BILL_MSG cascade constraints;
drop TABLE CCBADM.CI_BILL_MSGS cascade constraints;
drop TABLE CCBADM.CI_BILL_MSG_L cascade constraints;
drop TABLE CCBADM.CI_BILL_MSG_PRM cascade constraints;
drop TABLE CCBADM.CI_BILL_PERIOD cascade constraints;
drop TABLE CCBADM.CI_BILL_PERIOD_L cascade constraints;
drop TABLE CCBADM.CI_BILL_PER_SCH cascade constraints;
drop TABLE CCBADM.CI_BILL_ROUTING cascade constraints;
drop TABLE CCBADM.CI_BILL_RT_TYPE cascade constraints;
drop TABLE CCBADM.CI_BILL_RT_TYPE_L cascade constraints;
drop TABLE CCBADM.CI_BILL_RVW_SCH cascade constraints;
drop TABLE CCBADM.CI_BILL_SA cascade constraints;
drop TABLE CCBADM.CI_BILL_SCNR cascade constraints;
drop TABLE CCBADM.CI_BILL_SCNR_SQ cascade constraints;
drop TABLE CCBADM.CI_BILL_SEG_TYP cascade constraints;
drop TABLE CCBADM.CI_BILL_SEG_TYP_L cascade constraints;
drop TABLE CCBADM.CI_BPRT_GRP cascade constraints;
drop TABLE CCBADM.CI_BPRT_SGRP_SA cascade constraints;
drop TABLE CCBADM.CI_BPRT_SUBGRP cascade constraints;
drop TABLE CCBADM.CI_BSEG_CALC cascade constraints;
drop TABLE CCBADM.CI_BSEG_CALC_LN cascade constraints;
drop TABLE CCBADM.CI_BSEG_CL_CHAR cascade constraints;
drop TABLE CCBADM.CI_BSEG_EXCP cascade constraints;
drop TABLE CCBADM.CI_BSEG_ITEM cascade constraints;
drop TABLE CCBADM.CI_BSEG_MSG cascade constraints;
drop TABLE CCBADM.CI_BSEG_READ cascade constraints;
drop TABLE CCBADM.CI_BSEG_SQ cascade constraints;
drop TABLE CCBADM.CI_BUD_PLAN cascade constraints;
drop TABLE CCBADM.CI_BUD_PLAN_L cascade constraints;
drop TABLE CCBADM.CI_BUD_RVW cascade constraints;
drop TABLE CCBADM.CI_B_CHG_LINE cascade constraints;
drop TABLE CCBADM.CI_B_CHG_TMPLT cascade constraints;
drop TABLE CCBADM.CI_B_CHG_TMPLT_L cascade constraints;
drop TABLE CCBADM.CI_B_LN_CHAR cascade constraints;
drop TABLE CCBADM.CI_B_LN_UP_CHAR cascade constraints;
drop TABLE CCBADM.CI_B_TMPLT_LINE cascade constraints;
drop TABLE CCBADM.CI_B_TMPLT_LINE_L cascade constraints;
drop TABLE CCBADM.CI_B_TMPLT_SQ cascade constraints;
drop TABLE CCBADM.CI_B_TM_LN_CHA cascade constraints;
drop TABLE CCBADM.CI_CAL_GL cascade constraints;
drop TABLE CCBADM.CI_CAL_GL_L cascade constraints;
drop TABLE CCBADM.CI_CAL_PERIOD cascade constraints;
drop TABLE CCBADM.CI_CAL_PERIOD_L cascade constraints;
drop TABLE CCBADM.CI_CAMPAIGN cascade constraints;
drop TABLE CCBADM.CI_CAMPAIGN_L cascade constraints;
drop TABLE CCBADM.CI_CAMP_ALG cascade constraints;
drop TABLE CCBADM.CI_CAMP_FLD_TYPE cascade constraints;
drop TABLE CCBADM.CI_CAMP_FLD_TYPE_L cascade constraints;
drop TABLE CCBADM.CI_CASE_CHAR cascade constraints;
drop TABLE CCBADM.CI_CASE_LOG cascade constraints;
drop TABLE CCBADM.CI_CASE_LOG_PARM cascade constraints;
drop TABLE CCBADM.CI_CASE_STATUS cascade constraints;
drop TABLE CCBADM.CI_CASE_STATUS_L cascade constraints;
drop TABLE CCBADM.CI_CASE_ST_ALG cascade constraints;
drop TABLE CCBADM.CI_CASE_ST_CHTY cascade constraints;
drop TABLE CCBADM.CI_CASE_TR_RULE cascade constraints;
drop TABLE CCBADM.CI_CASE_TR_RULE_L cascade constraints;
drop TABLE CCBADM.CI_CASE_TYPE cascade constraints;
drop TABLE CCBADM.CI_CASE_TYPE_ALG cascade constraints;
drop TABLE CCBADM.CI_CASE_TYPE_L cascade constraints;
drop TABLE CCBADM.CI_CCL_CTL_ALG cascade constraints;
drop TABLE CCBADM.CI_CC_CHAR cascade constraints;
drop TABLE CCBADM.CI_CC_CL cascade constraints;
drop TABLE CCBADM.CI_CC_CL_L cascade constraints;
drop TABLE CCBADM.CI_CC_LOG cascade constraints;
drop TABLE CCBADM.CI_CC_TYPE cascade constraints;
drop TABLE CCBADM.CI_CC_TYPE_L cascade constraints;
drop TABLE CCBADM.CI_CEVT_CAN_RSN cascade constraints;
drop TABLE CCBADM.CI_CEVT_CAN_RSN_L cascade constraints;
drop TABLE CCBADM.CI_CHAR_DFLT cascade constraints;
drop TABLE CCBADM.CI_CHAR_DFLT_SV cascade constraints;
drop TABLE CCBADM.CI_CHG_LOG cascade constraints;
drop TABLE CCBADM.CI_CHTY_ADJTY cascade constraints;
drop TABLE CCBADM.CI_CHTY_CASETY cascade constraints;
drop TABLE CCBADM.CI_CHTY_CCTY cascade constraints;
drop TABLE CCBADM.CI_CHTY_COPTY cascade constraints;
drop TABLE CCBADM.CI_CHTY_COP_ETY cascade constraints;
drop TABLE CCBADM.CI_CHTY_DV_TTYP cascade constraints;
drop TABLE CCBADM.CI_CHTY_FATY cascade constraints;
drop TABLE CCBADM.CI_CHTY_ITTY cascade constraints;
drop TABLE CCBADM.CI_CHTY_MTTY cascade constraints;
drop TABLE CCBADM.CI_CHTY_SCMTY cascade constraints;
drop TABLE CCBADM.CI_CHTY_SPTY cascade constraints;
drop TABLE CCBADM.CI_CHTY_TOSTY cascade constraints;
drop TABLE CCBADM.CI_CHTY_UATY cascade constraints;
drop TABLE CCBADM.CI_CIS_DIVISION cascade constraints;
drop TABLE CCBADM.CI_CIS_DIVISION_L cascade constraints;
drop TABLE CCBADM.CI_CIS_DIV_CHAR cascade constraints;
drop TABLE CCBADM.CI_COLL_AGY cascade constraints;
drop TABLE CCBADM.CI_COLL_AGY_HIS cascade constraints;
drop TABLE CCBADM.CI_COLL_AGY_L cascade constraints;
drop TABLE CCBADM.CI_COLL_AGY_REF cascade constraints;
drop TABLE CCBADM.CI_COLL_CL cascade constraints;
drop TABLE CCBADM.CI_COLL_CL_CNTL cascade constraints;
drop TABLE CCBADM.CI_COLL_CL_CNTL_L cascade constraints;
drop TABLE CCBADM.CI_COLL_CL_L cascade constraints;
drop TABLE CCBADM.CI_COLL_CRIT cascade constraints;
drop TABLE CCBADM.CI_COLL_CRIT_CT cascade constraints;
drop TABLE CCBADM.CI_COLL_EVT cascade constraints;
drop TABLE CCBADM.CI_COLL_EVT_CC cascade constraints;
drop TABLE CCBADM.CI_COLL_EVT_TYP cascade constraints;
drop TABLE CCBADM.CI_COLL_EVT_TYP_L cascade constraints;
drop TABLE CCBADM.CI_COLL_PROC cascade constraints;
drop TABLE CCBADM.CI_COLL_PROC_SA cascade constraints;
drop TABLE CCBADM.CI_COLL_PROC_TM cascade constraints;
drop TABLE CCBADM.CI_COLL_PROC_TM_L cascade constraints;
drop TABLE CCBADM.CI_COLL_RESP cascade constraints;
drop TABLE CCBADM.CI_COL_REF cascade constraints;
drop TABLE CCBADM.CI_COL_REF_ALG cascade constraints;
drop TABLE CCBADM.CI_COL_REF_L cascade constraints;
drop TABLE CCBADM.CI_CONSV_PROG_CHAR cascade constraints;
drop TABLE CCBADM.CI_CONSV_PROG_L cascade constraints;
drop TABLE CCBADM.CI_CONT_QTY_TMP cascade constraints;
drop TABLE CCBADM.CI_CONT_QTY_TYP cascade constraints;
drop TABLE CCBADM.CI_CONT_QTY_TYP_L cascade constraints;
drop TABLE CCBADM.CI_COP cascade constraints;
drop TABLE CCBADM.CI_COP_CHAR cascade constraints;
drop TABLE CCBADM.CI_COP_EVT cascade constraints;
drop TABLE CCBADM.CI_COP_EVT_CHAR cascade constraints;
drop TABLE CCBADM.CI_COP_EVT_EXC cascade constraints;
drop TABLE CCBADM.CI_COP_EVT_EXP cascade constraints;
drop TABLE CCBADM.CI_COP_EVT_TYPE cascade constraints;
drop TABLE CCBADM.CI_COP_EVT_TYPE_L cascade constraints;
drop TABLE CCBADM.CI_COP_L cascade constraints;
drop TABLE CCBADM.CI_COP_TYPE cascade constraints;
drop TABLE CCBADM.CI_COP_TYPE_ALG cascade constraints;
drop TABLE CCBADM.CI_COP_TYPE_L cascade constraints;
drop TABLE CCBADM.CI_CR_RAT_HIST cascade constraints;
drop TABLE CCBADM.CI_CR_UNIT cascade constraints;
drop TABLE CCBADM.CI_CR_UNIT_L cascade constraints;
drop TABLE CCBADM.CI_CUST_CL cascade constraints;
drop TABLE CCBADM.CI_CUST_CL_CTRL cascade constraints;
drop TABLE CCBADM.CI_CUST_CL_L cascade constraints;
drop TABLE CCBADM.CI_CUST_CL_MSG cascade constraints;
drop TABLE CCBADM.CI_CUT_EVT cascade constraints;
drop TABLE CCBADM.CI_CUT_EVT_DEP cascade constraints;
drop TABLE CCBADM.CI_CUT_EVT_TYPE cascade constraints;
drop TABLE CCBADM.CI_CUT_EVT_TYPE_L cascade constraints;
drop TABLE CCBADM.CI_CUT_EVT_TYP_ALG cascade constraints;
drop TABLE CCBADM.CI_CUT_PROC cascade constraints;
drop TABLE CCBADM.CI_CUT_PROC_TMP cascade constraints;
drop TABLE CCBADM.CI_CUT_PROC_TMP_L cascade constraints;
drop TABLE CCBADM.CI_CUT_PROC_TM_ALG cascade constraints;
drop TABLE CCBADM.CI_CUT_RESP cascade constraints;
drop TABLE CCBADM.CI_CUT_RESP_DEP cascade constraints;
drop TABLE CCBADM.CI_CVAL_TMPL cascade constraints;
drop TABLE CCBADM.CI_CVAL_TOU_TMP cascade constraints;
drop TABLE CCBADM.CI_DCL cascade constraints;
drop TABLE CCBADM.CI_DC_ALG cascade constraints;
drop TABLE CCBADM.CI_DEBT_CL cascade constraints;
drop TABLE CCBADM.CI_DEBT_CL_L cascade constraints;
drop TABLE CCBADM.CI_DEG_DAY cascade constraints;
drop TABLE CCBADM.CI_DEP_CL cascade constraints;
drop TABLE CCBADM.CI_DEP_CL_L cascade constraints;
drop TABLE CCBADM.CI_DEP_CTL cascade constraints;
drop TABLE CCBADM.CI_DEP_CTL_CHAR cascade constraints;
drop TABLE CCBADM.CI_DEP_CTL_ST cascade constraints;
drop TABLE CCBADM.CI_DEP_RVW cascade constraints;
drop TABLE CCBADM.CI_DG_APP_SCHED cascade constraints;
drop TABLE CCBADM.CI_DISCON_LOC cascade constraints;
drop TABLE CCBADM.CI_DISCON_LOC_L cascade constraints;
drop TABLE CCBADM.CI_DISP_GRP cascade constraints;
drop TABLE CCBADM.CI_DISP_GRP_ALG cascade constraints;
drop TABLE CCBADM.CI_DISP_GRP_L cascade constraints;
drop TABLE CCBADM.CI_DISP_GRP_REP cascade constraints;
drop TABLE CCBADM.CI_DIV_TD_ROLE cascade constraints;
drop TABLE CCBADM.CI_DST_CD_CHAR cascade constraints;
drop TABLE CCBADM.CI_DST_CODE cascade constraints;
drop TABLE CCBADM.CI_DST_CODE_EFF cascade constraints;
drop TABLE CCBADM.CI_DST_CODE_L cascade constraints;
drop TABLE CCBADM.CI_DST_RULE cascade constraints;
drop TABLE CCBADM.CI_DST_RULE_ALG cascade constraints;
drop TABLE CCBADM.CI_DST_RULE_L cascade constraints;
drop TABLE CCBADM.CI_DV_TEST cascade constraints;
drop TABLE CCBADM.CI_DV_TEST_CHAR cascade constraints;
drop TABLE CCBADM.CI_DV_TEST_COMP cascade constraints;
drop TABLE CCBADM.CI_DV_TEST_EXCP cascade constraints;
drop TABLE CCBADM.CI_DV_TEST_RES cascade constraints;
drop TABLE CCBADM.CI_DV_TEST_SEL cascade constraints;
drop TABLE CCBADM.CI_DV_TEST_TYPE cascade constraints;
drop TABLE CCBADM.CI_DV_TEST_TYPE_L cascade constraints;
drop TABLE CCBADM.CI_DV_TTYP_CHAR cascade constraints;
drop TABLE CCBADM.CI_DV_TTYP_COMP cascade constraints;
drop TABLE CCBADM.CI_DV_TTYP_ITEM cascade constraints;
drop TABLE CCBADM.CI_DV_TTYP_MTR cascade constraints;
drop TABLE CCBADM.CI_ENRL cascade constraints;
drop TABLE CCBADM.CI_ENRL_ADDR cascade constraints;
drop TABLE CCBADM.CI_ENRL_CAN_RSN cascade constraints;
drop TABLE CCBADM.CI_ENRL_CAN_RSN_L cascade constraints;
drop TABLE CCBADM.CI_ENRL_CBK_RSN cascade constraints;
drop TABLE CCBADM.CI_ENRL_CBK_RSN_L cascade constraints;
drop TABLE CCBADM.CI_ENRL_FLD cascade constraints;
drop TABLE CCBADM.CI_ENRL_LOG cascade constraints;
drop TABLE CCBADM.CI_ENRL_PER_ID cascade constraints;
drop TABLE CCBADM.CI_ENRL_PER_NM cascade constraints;
drop TABLE CCBADM.CI_ENRL_PER_PHN cascade constraints;
drop TABLE CCBADM.CI_FAC_LVL_1 cascade constraints;
drop TABLE CCBADM.CI_FAC_LVL_1_2 cascade constraints;
drop TABLE CCBADM.CI_FAC_LVL_1_L cascade constraints;
drop TABLE CCBADM.CI_FAC_LVL_2 cascade constraints;
drop TABLE CCBADM.CI_FAC_LVL_2_3 cascade constraints;
drop TABLE CCBADM.CI_FAC_LVL_2_L cascade constraints;
drop TABLE CCBADM.CI_FAC_LVL_3 cascade constraints;
drop TABLE CCBADM.CI_FAC_LVL_3_L cascade constraints;
drop TABLE CCBADM.CI_FAC_LVL_NAME cascade constraints;
drop TABLE CCBADM.CI_FAC_LVL_NAME_L cascade constraints;
drop TABLE CCBADM.CI_FAPR_FATY cascade constraints;
drop TABLE CCBADM.CI_FAPR_TMPL cascade constraints;
drop TABLE CCBADM.CI_FA_CAN_RSN cascade constraints;
drop TABLE CCBADM.CI_FA_CAN_RSN_L cascade constraints;
drop TABLE CCBADM.CI_FA_CHAR cascade constraints;
drop TABLE CCBADM.CI_FA_CMPL_CTRL cascade constraints;
drop TABLE CCBADM.CI_FA_LOG cascade constraints;
drop TABLE CCBADM.CI_FA_REM cascade constraints;
drop TABLE CCBADM.CI_FA_REM_ALG cascade constraints;
drop TABLE CCBADM.CI_FA_REM_CD cascade constraints;
drop TABLE CCBADM.CI_FA_REM_CD_L cascade constraints;
drop TABLE CCBADM.CI_FA_REM_EXC cascade constraints;
drop TABLE CCBADM.CI_FA_REM_EXP cascade constraints;
drop TABLE CCBADM.CI_FA_RESCHED_RSN cascade constraints;
drop TABLE CCBADM.CI_FA_RESCHED_RSN_L cascade constraints;
drop TABLE CCBADM.CI_FA_STAGE_UP cascade constraints;
drop TABLE CCBADM.CI_FA_STEP cascade constraints;
drop TABLE CCBADM.CI_FA_STEP_TYPE cascade constraints;
drop TABLE CCBADM.CI_FA_STEP_TYPE_L cascade constraints;
drop TABLE CCBADM.CI_FA_STGUP_CHAR cascade constraints;
drop TABLE CCBADM.CI_FA_STGUP_EXC cascade constraints;
drop TABLE CCBADM.CI_FA_STGUP_REM cascade constraints;
drop TABLE CCBADM.CI_FA_STP_STGUP cascade constraints;
drop TABLE CCBADM.CI_FA_TYPE cascade constraints;
drop TABLE CCBADM.CI_FA_TYPE_CHAR cascade constraints;
drop TABLE CCBADM.CI_FA_TYPE_L cascade constraints;
drop TABLE CCBADM.CI_FA_TYPE_PROF cascade constraints;
drop TABLE CCBADM.CI_FA_TYPE_PROF_L cascade constraints;
drop TABLE CCBADM.CI_FO cascade constraints;
drop TABLE CCBADM.CI_FO_STG_DWN cascade constraints;
drop TABLE CCBADM.CI_FREQ cascade constraints;
drop TABLE CCBADM.CI_FREQ_L cascade constraints;
drop TABLE CCBADM.CI_FS_CL cascade constraints;
drop TABLE CCBADM.CI_FS_CL_DFLT cascade constraints;
drop TABLE CCBADM.CI_FS_CL_L cascade constraints;
drop TABLE CCBADM.CI_FS_CTRL cascade constraints;
drop TABLE CCBADM.CI_FS_DGRP cascade constraints;
drop TABLE CCBADM.CI_FS_OP_AREA cascade constraints;
drop TABLE CCBADM.CI_FT cascade constraints;
drop TABLE CCBADM.CI_FT_GL cascade constraints;
drop TABLE CCBADM.CI_FT_PROC cascade constraints;
drop TABLE CCBADM.CI_FUND cascade constraints;
drop TABLE CCBADM.CI_FUND_L cascade constraints;
drop TABLE CCBADM.CI_GEO_DFLT_SVC cascade constraints;
drop TABLE CCBADM.CI_GEO_TYP_DFLT cascade constraints;
drop TABLE CCBADM.CI_GL_DIVISION cascade constraints;
drop TABLE CCBADM.CI_GL_DIVISION_L cascade constraints;
drop TABLE CCBADM.CI_HI_LO_FACTOR cascade constraints;
drop TABLE CCBADM.CI_ID_TYPE cascade constraints;
drop TABLE CCBADM.CI_ID_TYPE_L cascade constraints;
drop TABLE CCBADM.CI_INTV_DATA cascade constraints;
drop TABLE CCBADM.CI_INTV_DS_EXC cascade constraints;
drop TABLE CCBADM.CI_INTV_PFRELTY cascade constraints;
drop TABLE CCBADM.CI_INTV_PFRELTY_L cascade constraints;
drop TABLE CCBADM.CI_INTV_PF_ALG cascade constraints;
drop TABLE CCBADM.CI_INTV_PF_L cascade constraints;
drop TABLE CCBADM.CI_INTV_PF_TYP_L cascade constraints;
drop TABLE CCBADM.CI_INTV_REG_ALG cascade constraints;
drop TABLE CCBADM.CI_INTV_REG_TYP cascade constraints;
drop TABLE CCBADM.CI_INTV_REG_TYP_L cascade constraints;
drop TABLE CCBADM.CI_INTV_VAL cascade constraints;
drop TABLE CCBADM.CI_INTV_VAL_SET cascade constraints;
drop TABLE CCBADM.CI_ITEM cascade constraints;
drop TABLE CCBADM.CI_ITEM_CHAR cascade constraints;
drop TABLE CCBADM.CI_ITEM_EQ cascade constraints;
drop TABLE CCBADM.CI_ITEM_LOC_HIS cascade constraints;
drop TABLE CCBADM.CI_ITEM_SQ_EST cascade constraints;
drop TABLE CCBADM.CI_ITEM_STK_LOC cascade constraints;
drop TABLE CCBADM.CI_ITEM_TYPE cascade constraints;
drop TABLE CCBADM.CI_ITEM_TYPE_EQ cascade constraints;
drop TABLE CCBADM.CI_ITEM_TYPE_L cascade constraints;
drop TABLE CCBADM.CI_ITEM_TYP_CHA cascade constraints;
drop TABLE CCBADM.CI_LANDLORD cascade constraints;
drop TABLE CCBADM.CI_LETTER_TMPL cascade constraints;
drop TABLE CCBADM.CI_LETTER_TMPL_L cascade constraints;
drop TABLE CCBADM.CI_LL_DETAIL cascade constraints;
drop TABLE CCBADM.CI_MATCH_EVT cascade constraints;
drop TABLE CCBADM.CI_MATCH_TYPE cascade constraints;
drop TABLE CCBADM.CI_MATCH_TYPE_L cascade constraints;
drop TABLE CCBADM.CI_MEVT_CAN_RSN cascade constraints;
drop TABLE CCBADM.CI_MEVT_CAN_RSN_L cascade constraints;
drop TABLE CCBADM.CI_MFG cascade constraints;
drop TABLE CCBADM.CI_MFG_L cascade constraints;
drop TABLE CCBADM.CI_MKTMSG_TYPE_ALG cascade constraints;
drop TABLE CCBADM.CI_MKTMSG_TYPE_CHAR cascade constraints;
drop TABLE CCBADM.CI_MKTMSG_TYPE_L cascade constraints;
drop TABLE CCBADM.CI_MODEL cascade constraints;
drop TABLE CCBADM.CI_MODEL_L cascade constraints;
drop TABLE CCBADM.CI_MRR_STGE_UP cascade constraints;
drop TABLE CCBADM.CI_MR_CHAR cascade constraints;
drop TABLE CCBADM.CI_MR_CYC cascade constraints;
drop TABLE CCBADM.CI_MR_CYC_L cascade constraints;
drop TABLE CCBADM.CI_MR_INSTR cascade constraints;
drop TABLE CCBADM.CI_MR_INSTR_L cascade constraints;
drop TABLE CCBADM.CI_MR_REM cascade constraints;
drop TABLE CCBADM.CI_MR_REM_ACTN cascade constraints;
drop TABLE CCBADM.CI_MR_REM_BMSG cascade constraints;
drop TABLE CCBADM.CI_MR_REM_EXCP cascade constraints;
drop TABLE CCBADM.CI_MR_RTE cascade constraints;
drop TABLE CCBADM.CI_MR_RTE_CHAR cascade constraints;
drop TABLE CCBADM.CI_MR_RTE_L cascade constraints;
drop TABLE CCBADM.CI_MR_RTE_TYPE cascade constraints;
drop TABLE CCBADM.CI_MR_RTE_TYPE_L cascade constraints;
drop TABLE CCBADM.CI_MR_SCHED cascade constraints;
drop TABLE CCBADM.CI_MR_SCHED_RTE cascade constraints;
drop TABLE CCBADM.CI_MR_SOURCE cascade constraints;
drop TABLE CCBADM.CI_MR_SOURCE_L cascade constraints;
drop TABLE CCBADM.CI_MR_STAGE_DWN cascade constraints;
drop TABLE CCBADM.CI_MR_STAGE_UP cascade constraints;
drop TABLE CCBADM.CI_MR_STGUP_CHAR cascade constraints;
drop TABLE CCBADM.CI_MR_STGUP_EXC cascade constraints;
drop TABLE CCBADM.CI_MR_WARN cascade constraints;
drop TABLE CCBADM.CI_MR_WARN_L cascade constraints;
drop TABLE CCBADM.CI_MTR_CFGTY_RL cascade constraints;
drop TABLE CCBADM.CI_MTR_CHAR cascade constraints;
drop TABLE CCBADM.CI_MTR_CONFIG_TY cascade constraints;
drop TABLE CCBADM.CI_MTR_CONFIG_TY_L cascade constraints;
drop TABLE CCBADM.CI_MTR_EQ cascade constraints;
drop TABLE CCBADM.CI_MTR_ID cascade constraints;
drop TABLE CCBADM.CI_MTR_ID_TYPE cascade constraints;
drop TABLE CCBADM.CI_MTR_ID_TYPE_L cascade constraints;
drop TABLE CCBADM.CI_MTR_LOC cascade constraints;
drop TABLE CCBADM.CI_MTR_LOC_HIS cascade constraints;
drop TABLE CCBADM.CI_MTR_LOC_L cascade constraints;
drop TABLE CCBADM.CI_MTR_STK_LOC cascade constraints;
drop TABLE CCBADM.CI_MTR_TYPE cascade constraints;
drop TABLE CCBADM.CI_MTR_TYPE_EQ cascade constraints;
drop TABLE CCBADM.CI_MTR_TYPE_L cascade constraints;
drop TABLE CCBADM.CI_MTR_TYP_CHAR cascade constraints;
drop TABLE CCBADM.CI_MTR_TY_CFGTY cascade constraints;
drop TABLE CCBADM.CI_MULT_ITEM cascade constraints;
drop TABLE CCBADM.CI_NB_RULE cascade constraints;
drop TABLE CCBADM.CI_NB_RULE_L cascade constraints;
drop TABLE CCBADM.CI_NB_RULE_PARM cascade constraints;
drop TABLE CCBADM.CI_NB_RULE_VER cascade constraints;
drop TABLE CCBADM.CI_NB_SA cascade constraints;
drop TABLE CCBADM.CI_NB_SCHED_PAY cascade constraints;
drop TABLE CCBADM.CI_NCD cascade constraints;
drop TABLE CCBADM.CI_NCD_TYPE cascade constraints;
drop TABLE CCBADM.CI_NCD_TYPE_L cascade constraints;
drop TABLE CCBADM.CI_NT_UP_XSPL cascade constraints;
drop TABLE CCBADM.CI_OD_EVT cascade constraints;
drop TABLE CCBADM.CI_OD_EVT_DEP cascade constraints;
drop TABLE CCBADM.CI_OD_EVT_TYPE cascade constraints;
drop TABLE CCBADM.CI_OD_EVT_TYPE_ALG cascade constraints;
drop TABLE CCBADM.CI_OD_EVT_TYPE_L cascade constraints;
drop TABLE CCBADM.CI_OD_PROC cascade constraints;
drop TABLE CCBADM.CI_OD_PROC_LOG cascade constraints;
drop TABLE CCBADM.CI_OD_PROC_LOGPARM cascade constraints;
drop TABLE CCBADM.CI_OD_PROC_OBJ cascade constraints;
drop TABLE CCBADM.CI_OD_PROC_TMP cascade constraints;
drop TABLE CCBADM.CI_OD_PROC_TMP_ALG cascade constraints;
drop TABLE CCBADM.CI_OD_PROC_TMP_L cascade constraints;
drop TABLE CCBADM.CI_OD_RESP cascade constraints;
drop TABLE CCBADM.CI_OD_RESP_DEP cascade constraints;
drop TABLE CCBADM.CI_OD_RULE_ALG cascade constraints;
drop TABLE CCBADM.CI_OEVT_CAN_RSN cascade constraints;
drop TABLE CCBADM.CI_OEVT_CAN_RSN_L cascade constraints;
drop TABLE CCBADM.CI_OP_AREA cascade constraints;
drop TABLE CCBADM.CI_OP_AREA_L cascade constraints;
drop TABLE CCBADM.CI_PAY cascade constraints;
drop TABLE CCBADM.CI_PAY_CAN_RSN cascade constraints;
drop TABLE CCBADM.CI_PAY_CAN_RSN_L cascade constraints;
drop TABLE CCBADM.CI_PAY_CHAR cascade constraints;
drop TABLE CCBADM.CI_PAY_EVENT cascade constraints;
drop TABLE CCBADM.CI_PAY_EVT_CHAR cascade constraints;
drop TABLE CCBADM.CI_PAY_EVT_EXCP cascade constraints;
drop TABLE CCBADM.CI_PAY_EXCP cascade constraints;
drop TABLE CCBADM.CI_PAY_METH cascade constraints;
drop TABLE CCBADM.CI_PAY_METH_L cascade constraints;
drop TABLE CCBADM.CI_PAY_SEG cascade constraints;
drop TABLE CCBADM.CI_PAY_SEG_TYPE cascade constraints;
drop TABLE CCBADM.CI_PAY_SEG_TYPE_L cascade constraints;
drop TABLE CCBADM.CI_PAY_ST cascade constraints;
drop TABLE CCBADM.CI_PAY_TMPL_L cascade constraints;
drop TABLE CCBADM.CI_PAY_TNDR cascade constraints;
drop TABLE CCBADM.CI_PAY_TNDR_CHAR cascade constraints;
drop TABLE CCBADM.CI_PAY_TNDR_ST cascade constraints;
drop TABLE CCBADM.CI_PAY_TNDR_ST_CHAR cascade constraints;
drop TABLE CCBADM.CI_PER_ADDR_OVRD cascade constraints;
drop TABLE CCBADM.CI_PER_ADDR_SEAS cascade constraints;
drop TABLE CCBADM.CI_PER_CHAR cascade constraints;
drop TABLE CCBADM.CI_PER_ID cascade constraints;
drop TABLE CCBADM.CI_PER_NAME cascade constraints;
drop TABLE CCBADM.CI_PER_PER cascade constraints;
drop TABLE CCBADM.CI_PER_PHONE cascade constraints;
drop TABLE CCBADM.CI_PER_REL_TYPE cascade constraints;
drop TABLE CCBADM.CI_PER_REL_TYPE_L cascade constraints;
drop TABLE CCBADM.CI_PEVT_DST_DTL cascade constraints;
drop TABLE CCBADM.CI_PEVT_DTL_ST cascade constraints;
drop TABLE CCBADM.CI_PFRELTY_PFTY cascade constraints;
drop TABLE CCBADM.CI_PKG cascade constraints;
drop TABLE CCBADM.CI_PKG_CRT cascade constraints;
drop TABLE CCBADM.CI_PKG_CRT_GRP cascade constraints;
drop TABLE CCBADM.CI_PKG_CRT_GRP_L cascade constraints;
drop TABLE CCBADM.CI_PKG_FLD_OVRD cascade constraints;
drop TABLE CCBADM.CI_PKG_FLD_OVRD_L cascade constraints;
drop TABLE CCBADM.CI_PKG_INSTR cascade constraints;
drop TABLE CCBADM.CI_PKG_INSTR_L cascade constraints;
drop TABLE CCBADM.CI_PKG_L cascade constraints;
drop TABLE CCBADM.CI_PKG_SA_TYPE cascade constraints;
drop TABLE CCBADM.CI_POST_DFLT cascade constraints;
drop TABLE CCBADM.CI_PP cascade constraints;
drop TABLE CCBADM.CI_PP_SCHED_PAY cascade constraints;
drop TABLE CCBADM.CI_PP_TYPE cascade constraints;
drop TABLE CCBADM.CI_PP_TYPE_L cascade constraints;
drop TABLE CCBADM.CI_PREM_CHAR cascade constraints;
drop TABLE CCBADM.CI_PREM_GEO cascade constraints;
drop TABLE CCBADM.CI_PREM_TYPE cascade constraints;
drop TABLE CCBADM.CI_PREM_TYPE_L cascade constraints;
drop TABLE CCBADM.CI_PRM_ALT_ADDR cascade constraints;
drop TABLE CCBADM.CI_PROP_DCL_RSN cascade constraints;
drop TABLE CCBADM.CI_PROP_DCL_RSN_L cascade constraints;
drop TABLE CCBADM.CI_PROTOCOL cascade constraints;
drop TABLE CCBADM.CI_PROTOCOL_L cascade constraints;
drop TABLE CCBADM.CI_QTE_RTE_TYPE cascade constraints;
drop TABLE CCBADM.CI_QTE_RTE_TYPE_L cascade constraints;
drop TABLE CCBADM.CI_QUOTE cascade constraints;
drop TABLE CCBADM.CI_QUOTE_DTL cascade constraints;
drop TABLE CCBADM.CI_QUOTE_RTG cascade constraints;
drop TABLE CCBADM.CI_RC cascade constraints;
drop TABLE CCBADM.CI_RC_CHAR cascade constraints;
drop TABLE CCBADM.CI_RC_CRT cascade constraints;
drop TABLE CCBADM.CI_RC_CRT_GRP cascade constraints;
drop TABLE CCBADM.CI_RC_CRT_GRP_L cascade constraints;
drop TABLE CCBADM.CI_RC_GL_DST cascade constraints;
drop TABLE CCBADM.CI_RC_L cascade constraints;
drop TABLE CCBADM.CI_RC_XREF cascade constraints;
drop TABLE CCBADM.CI_RDR_TMPL cascade constraints;
drop TABLE CCBADM.CI_READER_REM cascade constraints;
drop TABLE CCBADM.CI_READER_REM_L cascade constraints;
drop TABLE CCBADM.CI_READ_OUT_TYP cascade constraints;
drop TABLE CCBADM.CI_READ_OUT_TYP_L cascade constraints;
drop TABLE CCBADM.CI_REBATE_CLAIM_CHAR cascade constraints;
drop TABLE CCBADM.CI_REBATE_CLAIM_LOG cascade constraints;
drop TABLE CCBADM.CI_REBATE_CLAIM_LOG_PARM cascade constraints;
drop TABLE CCBADM.CI_REBATE_DEFN_L cascade constraints;
drop TABLE CCBADM.CI_REBATE_LINE_CHAR cascade constraints;
drop TABLE CCBADM.CI_REG cascade constraints;
drop TABLE CCBADM.CI_REG_CHAR cascade constraints;
drop TABLE CCBADM.CI_REG_DATA cascade constraints;
drop TABLE CCBADM.CI_REG_DATA_SET cascade constraints;
drop TABLE CCBADM.CI_REG_DS_EXC cascade constraints;
drop TABLE CCBADM.CI_REG_DS_EXP cascade constraints;
drop TABLE CCBADM.CI_REG_READ cascade constraints;
drop TABLE CCBADM.CI_REG_RULE cascade constraints;
drop TABLE CCBADM.CI_REG_RULE_L cascade constraints;
drop TABLE CCBADM.CI_REP cascade constraints;
drop TABLE CCBADM.CI_REPL_ACCT cascade constraints;
drop TABLE CCBADM.CI_REPL_CNTL cascade constraints;
drop TABLE CCBADM.CI_REP_L cascade constraints;
drop TABLE CCBADM.CI_RETIRE_RSN cascade constraints;
drop TABLE CCBADM.CI_RETIRE_RSN_L cascade constraints;
drop TABLE CCBADM.CI_REV_CL cascade constraints;
drop TABLE CCBADM.CI_REV_CL_L cascade constraints;
drop TABLE CCBADM.CI_RR_STAGE_UP cascade constraints;
drop TABLE CCBADM.CI_RS cascade constraints;
drop TABLE CCBADM.CI_RS_BMSG cascade constraints;
drop TABLE CCBADM.CI_RS_L cascade constraints;
drop TABLE CCBADM.CI_RS_MTR_CFGTY cascade constraints;
drop TABLE CCBADM.CI_RS_REG_RULE cascade constraints;
drop TABLE CCBADM.CI_RS_SQ_RULE cascade constraints;
drop TABLE CCBADM.CI_RS_SUB_RS cascade constraints;
drop TABLE CCBADM.CI_RV cascade constraints;
drop TABLE CCBADM.CI_RV_L cascade constraints;
drop TABLE CCBADM.CI_SATY_ALG cascade constraints;
drop TABLE CCBADM.CI_SATY_COPTY cascade constraints;
drop TABLE CCBADM.CI_SATY_SARELTY cascade constraints;
drop TABLE CCBADM.CI_SATY_TMAPRTY cascade constraints;
drop TABLE CCBADM.CI_SAT_ADJ_PROF cascade constraints;
drop TABLE CCBADM.CI_SAT_NB_RULE cascade constraints;
drop TABLE CCBADM.CI_SAT_PFRELTY cascade constraints;
drop TABLE CCBADM.CI_SA_CHAR cascade constraints;
drop TABLE CCBADM.CI_SA_CHAR_TMP cascade constraints;
drop TABLE CCBADM.CI_SA_CONTERM cascade constraints;
drop TABLE CCBADM.CI_SA_CONT_QTY cascade constraints;
drop TABLE CCBADM.CI_SA_COP cascade constraints;
drop TABLE CCBADM.CI_SA_COP_OVRD cascade constraints;
drop TABLE CCBADM.CI_SA_INTV_PF cascade constraints;
drop TABLE CCBADM.CI_SA_MSG cascade constraints;
drop TABLE CCBADM.CI_SA_NB_PARM cascade constraints;
drop TABLE CCBADM.CI_SA_RCHG_HIST cascade constraints;
drop TABLE CCBADM.CI_SA_REL cascade constraints;
drop TABLE CCBADM.CI_SA_REL_TYPE cascade constraints;
drop TABLE CCBADM.CI_SA_REL_TYPE_L cascade constraints;
drop TABLE CCBADM.CI_SA_RS_HIST cascade constraints;
drop TABLE CCBADM.CI_SA_SP cascade constraints;
drop TABLE CCBADM.CI_SA_SP_CHAR cascade constraints;
drop TABLE CCBADM.CI_SA_SP_FA cascade constraints;
drop TABLE CCBADM.CI_SA_SP_TYPE cascade constraints;
drop TABLE CCBADM.CI_SA_TC cascade constraints;
drop TABLE CCBADM.CI_SA_TOU_MAP cascade constraints;
drop TABLE CCBADM.CI_SA_TYPE cascade constraints;
drop TABLE CCBADM.CI_SA_TYPE_BC cascade constraints;
drop TABLE CCBADM.CI_SA_TYPE_CHAR cascade constraints;
drop TABLE CCBADM.CI_SA_TYPE_L cascade constraints;
drop TABLE CCBADM.CI_SA_TYPE_RS cascade constraints;
drop TABLE CCBADM.CI_SCM cascade constraints;
drop TABLE CCBADM.CI_SCMTY_SATY cascade constraints;
drop TABLE CCBADM.CI_SCMTY_SUBCAT cascade constraints;
drop TABLE CCBADM.CI_SCMTY_SUBCAT_L cascade constraints;
drop TABLE CCBADM.CI_SCM_ACCT cascade constraints;
drop TABLE CCBADM.CI_SCM_CHAR cascade constraints;
drop TABLE CCBADM.CI_SCM_NCTV_RSN cascade constraints;
drop TABLE CCBADM.CI_SCM_NCTV_RSN_L cascade constraints;
drop TABLE CCBADM.CI_SCM_TYPE cascade constraints;
drop TABLE CCBADM.CI_SCM_TYPE_ALG cascade constraints;
drop TABLE CCBADM.CI_SCM_TYPE_L cascade constraints;
drop TABLE CCBADM.CI_SC_EVT cascade constraints;
drop TABLE CCBADM.CI_SC_EVTTY_ALG cascade constraints;
drop TABLE CCBADM.CI_SC_EVT_FT cascade constraints;
drop TABLE CCBADM.CI_SC_EVT_TYPE cascade constraints;
drop TABLE CCBADM.CI_SC_EVT_TYPE_L cascade constraints;
drop TABLE CCBADM.CI_SEV_CRIT cascade constraints;
drop TABLE CCBADM.CI_SEV_EVT cascade constraints;
drop TABLE CCBADM.CI_SEV_EVT_CC cascade constraints;
drop TABLE CCBADM.CI_SEV_EVT_DEP cascade constraints;
drop TABLE CCBADM.CI_SEV_EVT_FA cascade constraints;
drop TABLE CCBADM.CI_SEV_EVT_TYPE cascade constraints;
drop TABLE CCBADM.CI_SEV_EVT_TYPE_L cascade constraints;
drop TABLE CCBADM.CI_SEV_PROC cascade constraints;
drop TABLE CCBADM.CI_SEV_PROC_TMP cascade constraints;
drop TABLE CCBADM.CI_SEV_PROC_TMP_L cascade constraints;
drop TABLE CCBADM.CI_SEV_RESP cascade constraints;
drop TABLE CCBADM.CI_SEV_RESP_DEP cascade constraints;
drop TABLE CCBADM.CI_SIC cascade constraints;
drop TABLE CCBADM.CI_SIC_L cascade constraints;
drop TABLE CCBADM.CI_SPR cascade constraints;
drop TABLE CCBADM.CI_SPR_BMSG cascade constraints;
drop TABLE CCBADM.CI_SPR_L cascade constraints;
drop TABLE CCBADM.CI_SPR_POST cascade constraints;
drop TABLE CCBADM.CI_SPR_SARELTY cascade constraints;
drop TABLE CCBADM.CI_SPR_VALID cascade constraints;
drop TABLE CCBADM.CI_SPTY_ITEMTY cascade constraints;
drop TABLE CCBADM.CI_SPTY_MTRTY cascade constraints;
drop TABLE CCBADM.CI_SP_CHAR cascade constraints;
drop TABLE CCBADM.CI_SP_EQ cascade constraints;
drop TABLE CCBADM.CI_SP_GEO cascade constraints;
drop TABLE CCBADM.CI_SP_ITEM_EVT cascade constraints;
drop TABLE CCBADM.CI_SP_ITEM_HIST cascade constraints;
drop TABLE CCBADM.CI_SP_MTR_EVT cascade constraints;
drop TABLE CCBADM.CI_SP_MTR_HIST cascade constraints;
drop TABLE CCBADM.CI_SP_MULT_ITEM cascade constraints;
drop TABLE CCBADM.CI_SP_OP_AREA cascade constraints;
drop TABLE CCBADM.CI_SP_RTE cascade constraints;
drop TABLE CCBADM.CI_SP_RTE_CFG cascade constraints;
drop TABLE CCBADM.CI_SP_TYPE cascade constraints;
drop TABLE CCBADM.CI_SP_TYPE_CHAR cascade constraints;
drop TABLE CCBADM.CI_SP_TYPE_EQ cascade constraints;
drop TABLE CCBADM.CI_SP_TYPE_L cascade constraints;
drop TABLE CCBADM.CI_SQI cascade constraints;
drop TABLE CCBADM.CI_SQI_L cascade constraints;
drop TABLE CCBADM.CI_SQ_RULE cascade constraints;
drop TABLE CCBADM.CI_SQ_RULE_L cascade constraints;
drop TABLE CCBADM.CI_SS_ADDR_OVRD cascade constraints;
drop TABLE CCBADM.CI_SS_OPT cascade constraints;
drop TABLE CCBADM.CI_SS_OPT_COP cascade constraints;
drop TABLE CCBADM.CI_SS_OPT_IP cascade constraints;
drop TABLE CCBADM.CI_SS_OPT_L cascade constraints;
drop TABLE CCBADM.CI_SS_OPT_TC cascade constraints;
drop TABLE CCBADM.CI_SS_OPT_TMAP cascade constraints;
drop TABLE CCBADM.CI_SS_PHONE_OVRD cascade constraints;
drop TABLE CCBADM.CI_STK_LOC cascade constraints;
drop TABLE CCBADM.CI_STK_LOC_CHAR cascade constraints;
drop TABLE CCBADM.CI_STK_LOC_L cascade constraints;
drop TABLE CCBADM.CI_STM cascade constraints;
drop TABLE CCBADM.CI_STM_CNST cascade constraints;
drop TABLE CCBADM.CI_STM_CNST_DTL cascade constraints;
drop TABLE CCBADM.CI_STM_CYC cascade constraints;
drop TABLE CCBADM.CI_STM_CYC_L cascade constraints;
drop TABLE CCBADM.CI_STM_CYC_SCH cascade constraints;
drop TABLE CCBADM.CI_STM_DTL cascade constraints;
drop TABLE CCBADM.CI_STM_RTE_TY cascade constraints;
drop TABLE CCBADM.CI_STM_RTE_TY_L cascade constraints;
drop TABLE CCBADM.CI_SVC_RTE_STG_DWN cascade constraints;
drop TABLE CCBADM.CI_SVC_TYPE cascade constraints;
drop TABLE CCBADM.CI_SVC_TYPE_L cascade constraints;
drop TABLE CCBADM.CI_SVC_TYP_DFLT cascade constraints;
drop TABLE CCBADM.CI_TAX_EX_TYPE cascade constraints;
drop TABLE CCBADM.CI_TAX_EX_TYPE_L cascade constraints;
drop TABLE CCBADM.CI_TC cascade constraints;
drop TABLE CCBADM.CI_TC_L cascade constraints;
drop TABLE CCBADM.CI_TENDER_TYPE cascade constraints;
drop TABLE CCBADM.CI_TENDER_TYPE_L cascade constraints;
drop TABLE CCBADM.CI_THRD_PTY cascade constraints;
drop TABLE CCBADM.CI_THRD_PTY_L cascade constraints;
drop TABLE CCBADM.CI_TMAP_COM_CAL cascade constraints;
drop TABLE CCBADM.CI_TMAP_COM_DAY cascade constraints;
drop TABLE CCBADM.CI_TMAP_COM_WK cascade constraints;
drop TABLE CCBADM.CI_TMAP_REL cascade constraints;
drop TABLE CCBADM.CI_TMAP_RELTY cascade constraints;
drop TABLE CCBADM.CI_TMAP_RELTY_L cascade constraints;
drop TABLE CCBADM.CI_TMAP_TMPL cascade constraints;
drop TABLE CCBADM.CI_TMAP_TMPL_L cascade constraints;
drop TABLE CCBADM.CI_TMAP_TYPE cascade constraints;
drop TABLE CCBADM.CI_TMAP_TYPE_L cascade constraints;
drop TABLE CCBADM.CI_TMAP_TYP_ALG cascade constraints;
drop TABLE CCBADM.CI_TNDR_CTL cascade constraints;
drop TABLE CCBADM.CI_TNDR_CTL_CHAR cascade constraints;
drop TABLE CCBADM.CI_TNDR_CTL_ST cascade constraints;
drop TABLE CCBADM.CI_TNDR_DEP cascade constraints;
drop TABLE CCBADM.CI_TNDR_END_BAL cascade constraints;
drop TABLE CCBADM.CI_TNDR_SRCE cascade constraints;
drop TABLE CCBADM.CI_TNDR_SRCE_L cascade constraints;
drop TABLE CCBADM.CI_TNDR_ST_EXCP cascade constraints;
drop TABLE CCBADM.CI_TOS cascade constraints;
drop TABLE CCBADM.CI_TOS_CAN_RSN cascade constraints;
drop TABLE CCBADM.CI_TOS_CAN_RSN_L cascade constraints;
drop TABLE CCBADM.CI_TOS_CE cascade constraints;
drop TABLE CCBADM.CI_TOS_CHAR cascade constraints;
drop TABLE CCBADM.CI_TOS_SA cascade constraints;
drop TABLE CCBADM.CI_TOS_TYPE cascade constraints;
drop TABLE CCBADM.CI_TOS_TYPE_CE cascade constraints;
drop TABLE CCBADM.CI_TOS_TYPE_L cascade constraints;
drop TABLE CCBADM.CI_TOU cascade constraints;
drop TABLE CCBADM.CI_TOU_BF_VAL cascade constraints;
drop TABLE CCBADM.CI_TOU_CONT_VAL cascade constraints;
drop TABLE CCBADM.CI_TOU_DATA cascade constraints;
drop TABLE CCBADM.CI_TOU_DATA_SET cascade constraints;
drop TABLE CCBADM.CI_TOU_DS_EXC cascade constraints;
drop TABLE CCBADM.CI_TOU_DS_EXP cascade constraints;
drop TABLE CCBADM.CI_TOU_GRP cascade constraints;
drop TABLE CCBADM.CI_TOU_GRP_L cascade constraints;
drop TABLE CCBADM.CI_TOU_GRP_TOU cascade constraints;
drop TABLE CCBADM.CI_TOU_L cascade constraints;
drop TABLE CCBADM.CI_TOU_MAP cascade constraints;
drop TABLE CCBADM.CI_TOU_MAP_L cascade constraints;
drop TABLE CCBADM.CI_TREND cascade constraints;
drop TABLE CCBADM.CI_TREND_AREA cascade constraints;
drop TABLE CCBADM.CI_TREND_AREA_L cascade constraints;
drop TABLE CCBADM.CI_TREND_CL cascade constraints;
drop TABLE CCBADM.CI_TREND_CL_L cascade constraints;
drop TABLE CCBADM.CI_TRG cascade constraints;
drop TABLE CCBADM.CI_TRG_FLD cascade constraints;
drop TABLE CCBADM.CI_TST_COMP_TYP cascade constraints;
drop TABLE CCBADM.CI_TST_COMP_TYP_L cascade constraints;
drop TABLE CCBADM.CI_TST_RES_TYP cascade constraints;
drop TABLE CCBADM.CI_TST_RES_TYP_L cascade constraints;
drop TABLE CCBADM.CI_TURN_IN cascade constraints;
drop TABLE CCBADM.CI_UA cascade constraints;
drop TABLE CCBADM.CI_UATY_TOSTY cascade constraints;
drop TABLE CCBADM.CI_UA_CHAR cascade constraints;
drop TABLE CCBADM.CI_UA_PER cascade constraints;
drop TABLE CCBADM.CI_UA_TYPE cascade constraints;
drop TABLE CCBADM.CI_UA_TYPE_ALG cascade constraints;
drop TABLE CCBADM.CI_UA_TYPE_L cascade constraints;
drop TABLE CCBADM.CI_UOM cascade constraints;
drop TABLE CCBADM.CI_UOM_L cascade constraints;
drop TABLE CCBADM.CI_VAL_SUB_SATY cascade constraints;
drop TABLE CCBADM.CI_WO_CNTL cascade constraints;
drop TABLE CCBADM.CI_WO_CNTL_L cascade constraints;
drop TABLE CCBADM.CI_WO_CRIT cascade constraints;
drop TABLE CCBADM.CI_WO_DEBT_CL cascade constraints;
drop TABLE CCBADM.CI_WO_DEBT_CL_L cascade constraints;
drop TABLE CCBADM.CI_WO_EVT cascade constraints;
drop TABLE CCBADM.CI_WO_EVT_CC cascade constraints;
drop TABLE CCBADM.CI_WO_EVT_TYP cascade constraints;
drop TABLE CCBADM.CI_WO_EVT_TYP_L cascade constraints;
drop TABLE CCBADM.CI_WO_PROC cascade constraints;
drop TABLE CCBADM.CI_WO_PROC_SA cascade constraints;
drop TABLE CCBADM.CI_WO_PROC_TMPL cascade constraints;
drop TABLE CCBADM.CI_WO_PROC_TMPL_L cascade constraints;
drop TABLE CCBADM.CI_WO_RESP cascade constraints;
drop TABLE CCBADM.F1_BKT_CONFIG_L cascade constraints;
drop TABLE CCBADM.F1_BKT_CONFIG_REL_OBJ cascade constraints;
drop TABLE CCBADM.F1_BKT_CONFIG_VAL_L cascade constraints;
drop TABLE CCBADM.C1_INITIATIVE_CRITERIA_CHAR cascade constraints;
drop TABLE CCBADM.C1_INITIATIVE_CRITERIA_L cascade constraints;
drop TABLE CCBADM.C1_INITIATIVE_REL_OBJ cascade constraints;
drop TABLE CCBADM.C1_REPRESENTATIVE_CHAR cascade constraints;
drop TABLE CCBADM.C1_REPRESENTATIVE_L cascade constraints;
drop TABLE CCBADM.C1_REPRESENTATIVE_LOG cascade constraints;
drop TABLE CCBADM.C1_REPRESENTATIVE_LOG_PARM cascade constraints;
drop TABLE CCBADM.C1_REP_GRP_MEM cascade constraints;
drop TABLE CCBADM.CM_DD_FILE_K cascade constraints;
drop TABLE CCBADM.CM_DD_FILE_CHAR cascade constraints;
drop TABLE CCBADM.CM_DD_FILE_LOG cascade constraints;
drop TABLE CCBADM.CM_DD_FILE_LOG_PARM cascade constraints;
drop TABLE CCBADM.CM_CUST_TIL cascade constraints;
drop TABLE CCBADM.CM_CUST_TIL_K cascade constraints;
drop TABLE CCBADM.CM_PROD_TIL_K cascade constraints;
drop TABLE CCBADM.CM_PROD_TIL_CHAR cascade constraints;
drop TABLE CCBADM.CM_PROD_TIL_LOG cascade constraints;
drop TABLE CCBADM.CM_PROD_TIL_LOG_PARM cascade constraints;
drop TABLE CCBADM.CM_PROD_TIL_DETAILS_K cascade constraints;
drop TABLE MDMADM.CI_UT_INSTL cascade constraints;
drop TABLE MDMADM.CI_UT_INSTL_DTL cascade constraints;
drop TABLE MDMADM.CI_MD_TBL cascade constraints;
drop TABLE MDMADM.CI_ACC_GRP cascade constraints;
drop TABLE MDMADM.CI_ACC_GRP_DAR cascade constraints;
drop TABLE MDMADM.CI_ACC_GRP_L cascade constraints;
drop TABLE MDMADM.CI_ALG cascade constraints;
drop TABLE MDMADM.CI_ALG_L cascade constraints;
drop TABLE MDMADM.CI_ALG_PARM cascade constraints;
drop TABLE MDMADM.CI_ALG_TYPE cascade constraints;
drop TABLE MDMADM.CI_ALG_TYPE_L cascade constraints;
drop TABLE MDMADM.CI_ALG_TYPE_PRM cascade constraints;
drop TABLE MDMADM.CI_ALG_TYPE_PRM_L cascade constraints;
drop TABLE MDMADM.CI_ALG_VER cascade constraints;
drop TABLE MDMADM.CI_APP_SVC_ACC cascade constraints;
drop TABLE MDMADM.CI_APP_SVC_SCTY cascade constraints;
drop TABLE MDMADM.CI_ARC_ROOT_INST cascade constraints;
drop TABLE MDMADM.CI_ARC_ROOT_OBJ cascade constraints;
drop TABLE MDMADM.CI_ARC_ROOT_PK cascade constraints;
drop TABLE MDMADM.CI_AUDIT cascade constraints;
drop TABLE MDMADM.CI_BATCH_CTRL cascade constraints;
drop TABLE MDMADM.CI_BATCH_CTRL_ALG cascade constraints;
drop TABLE MDMADM.CI_BATCH_CTRL_L cascade constraints;
drop TABLE MDMADM.CI_BATCH_CTRL_P cascade constraints;
drop TABLE MDMADM.CI_BATCH_CTRL_P_L cascade constraints;
drop TABLE MDMADM.CI_BATCH_INST cascade constraints;
drop TABLE MDMADM.CI_BATCH_JOB cascade constraints;
drop TABLE MDMADM.CI_BATCH_JOB_PRM cascade constraints;
drop TABLE MDMADM.CI_BATCH_RUN cascade constraints;
drop TABLE MDMADM.CI_BATCH_THD cascade constraints;
drop TABLE MDMADM.CI_CAL_HOL cascade constraints;
drop TABLE MDMADM.CI_CAL_HOL_L cascade constraints;
drop TABLE MDMADM.CI_CAL_WORK cascade constraints;
drop TABLE MDMADM.CI_CAL_WORK_L cascade constraints;
drop TABLE MDMADM.CI_CHAR_ENTITY cascade constraints;
drop TABLE MDMADM.CI_CHAR_TYPE cascade constraints;
drop TABLE MDMADM.CI_CHAR_TYPE_L cascade constraints;
drop TABLE MDMADM.CI_CHAR_VAL cascade constraints;
drop TABLE MDMADM.CI_CHAR_VAL_L cascade constraints;
drop TABLE MDMADM.CI_CHTY_TDTY cascade constraints;
drop TABLE MDMADM.CI_CNV_DUP_KEY cascade constraints;
drop TABLE MDMADM.CI_CNV_KEY_TMP cascade constraints;
drop TABLE MDMADM.CI_COUNTRY cascade constraints;
drop TABLE MDMADM.CI_COUNTRY_L cascade constraints;
drop TABLE MDMADM.CI_CURRENCY_CD cascade constraints;
drop TABLE MDMADM.CI_CURRENCY_CD_L cascade constraints;
drop TABLE MDMADM.CI_DAR cascade constraints;
drop TABLE MDMADM.CI_DAR_L cascade constraints;
drop TABLE MDMADM.CI_DAR_USR cascade constraints;
drop TABLE MDMADM.CI_DATA_DIFF cascade constraints;
drop TABLE MDMADM.CI_DATA_DIFF_PK cascade constraints;
drop TABLE MDMADM.CI_DB_INSTR cascade constraints;
drop TABLE MDMADM.CI_DB_INSTR_ALG cascade constraints;
drop TABLE MDMADM.CI_DB_INSTR_L cascade constraints;
drop TABLE MDMADM.CI_DB_INST_OVRD cascade constraints;
drop TABLE MDMADM.CI_DB_PROC cascade constraints;
drop TABLE MDMADM.CI_DB_PROC_L cascade constraints;
drop TABLE MDMADM.CI_DISP_ICON cascade constraints;
drop TABLE MDMADM.CI_DISP_ICON_L cascade constraints;
drop TABLE MDMADM.CI_DISP_PROF cascade constraints;
drop TABLE MDMADM.CI_DISP_PROF_L cascade constraints;
drop TABLE MDMADM.CI_ENV_REF cascade constraints;
drop TABLE MDMADM.CI_ENV_REF_L cascade constraints;
drop TABLE MDMADM.CI_FK_REF cascade constraints;
drop TABLE MDMADM.CI_FK_REF_L cascade constraints;
drop TABLE MDMADM.CI_FUNC cascade constraints;
drop TABLE MDMADM.CI_FUNC_FLD cascade constraints;
drop TABLE MDMADM.CI_FUNC_FLD_L cascade constraints;
drop TABLE MDMADM.CI_FUNC_L cascade constraints;
drop TABLE MDMADM.CI_GEO_TYPE cascade constraints;
drop TABLE MDMADM.CI_GEO_TYPE_L cascade constraints;
drop TABLE MDMADM.CI_INSTALL_ALG cascade constraints;
drop TABLE MDMADM.CI_INSTALL_MSG cascade constraints;
drop TABLE MDMADM.CI_INSTALL_MSG_L cascade constraints;
drop TABLE MDMADM.CI_INSTALL_PROD cascade constraints;
drop TABLE MDMADM.CI_LANGUAGE cascade constraints;
drop TABLE MDMADM.CI_LOOKUP_FIELD cascade constraints;
drop TABLE MDMADM.CI_LOOKUP_VAL cascade constraints;
drop TABLE MDMADM.CI_LOOKUP_VAL_L cascade constraints;
drop TABLE MDMADM.CI_MD_ATT_TY cascade constraints;
drop TABLE MDMADM.CI_MD_AT_DTL cascade constraints;
drop TABLE MDMADM.CI_MD_AT_DTL_L cascade constraints;
drop TABLE MDMADM.CI_MD_CONST cascade constraints;
drop TABLE MDMADM.CI_MD_CONST_FLD cascade constraints;
drop TABLE MDMADM.CI_MD_CTL cascade constraints;
drop TABLE MDMADM.CI_MD_CTL_L cascade constraints;
drop TABLE MDMADM.CI_MD_CTL_TMPL cascade constraints;
drop TABLE MDMADM.CI_MD_ELTY cascade constraints;
drop TABLE MDMADM.CI_MD_ELTY_AT cascade constraints;
drop TABLE MDMADM.CI_MD_ELTY_L cascade constraints;
drop TABLE MDMADM.CI_MD_FLD cascade constraints;
drop TABLE MDMADM.CI_MD_FLD_L cascade constraints;
drop TABLE MDMADM.CI_MD_LOOKUP_F cascade constraints;
drop TABLE MDMADM.CI_MD_MENU cascade constraints;
drop TABLE MDMADM.CI_MD_MENU_IMOD cascade constraints;
drop TABLE MDMADM.CI_MD_MENU_ITEM cascade constraints;
drop TABLE MDMADM.CI_MD_MENU_ITEM_L cascade constraints;
drop TABLE MDMADM.CI_MD_MENU_L cascade constraints;
drop TABLE MDMADM.CI_MD_MENU_LINE cascade constraints;
drop TABLE MDMADM.CI_MD_MENU_LINE_L cascade constraints;
drop TABLE MDMADM.CI_MD_MENU_MOD cascade constraints;
drop TABLE MDMADM.CI_MD_MO cascade constraints;
drop TABLE MDMADM.CI_MD_MO_ALG cascade constraints;
drop TABLE MDMADM.CI_MD_MO_L cascade constraints;
drop TABLE MDMADM.CI_MD_MO_OPT cascade constraints;
drop TABLE MDMADM.CI_MD_MO_TBL cascade constraints;
drop TABLE MDMADM.CI_MD_MO_WRK cascade constraints;
drop TABLE MDMADM.CI_MD_MSG cascade constraints;
drop TABLE MDMADM.CI_MD_MSG_L cascade constraints;
drop TABLE MDMADM.CI_MD_NAV cascade constraints;
drop TABLE MDMADM.CI_MD_PDF cascade constraints;
drop TABLE MDMADM.CI_MD_PDF_VAL cascade constraints;
drop TABLE MDMADM.CI_MD_PRG_COM cascade constraints;
drop TABLE MDMADM.CI_MD_PRG_ELEM cascade constraints;
drop TABLE MDMADM.CI_MD_PRG_EL_AT cascade constraints;
drop TABLE MDMADM.CI_MD_PRG_LOC cascade constraints;
drop TABLE MDMADM.CI_MD_PRG_MOD cascade constraints;
drop TABLE MDMADM.CI_MD_PRG_SEC cascade constraints;
drop TABLE MDMADM.CI_MD_PRG_SQL cascade constraints;
drop TABLE MDMADM.CI_MD_PRG_TAB cascade constraints;
drop TABLE MDMADM.CI_MD_PRG_VAR cascade constraints;
drop TABLE MDMADM.CI_MD_RPT cascade constraints;
drop TABLE MDMADM.CI_MD_RPT_L cascade constraints;
drop TABLE MDMADM.CI_MD_RPT_LBL cascade constraints;
drop TABLE MDMADM.CI_MD_RPT_PARM cascade constraints;
drop TABLE MDMADM.CI_MD_RPT_PARM_L cascade constraints;
drop TABLE MDMADM.CI_MD_SO cascade constraints;
drop TABLE MDMADM.CI_MD_SOCG cascade constraints;
drop TABLE MDMADM.CI_MD_SOCG_FLD cascade constraints;
drop TABLE MDMADM.CI_MD_SOCG_FLDAT cascade constraints;
drop TABLE MDMADM.CI_MD_SOCG_L cascade constraints;
drop TABLE MDMADM.CI_MD_SOCG_SORT cascade constraints;
drop TABLE MDMADM.CI_MD_SO_L cascade constraints;
drop TABLE MDMADM.CI_MD_SO_RSFLD cascade constraints;
drop TABLE MDMADM.CI_MD_SO_RSFLDAT cascade constraints;
drop TABLE MDMADM.CI_MD_SRC_TYPE cascade constraints;
drop TABLE MDMADM.CI_MD_SRC_TYPE_L cascade constraints;
drop TABLE MDMADM.CI_MD_SVC cascade constraints;
drop TABLE MDMADM.CI_MD_SVC_L cascade constraints;
drop TABLE MDMADM.CI_MD_SVC_PRG cascade constraints;
drop TABLE MDMADM.CI_MD_TAB_MOD cascade constraints;
drop TABLE MDMADM.CI_MD_TBL_FLD cascade constraints;
drop TABLE MDMADM.CI_MD_TBL_FLD_L cascade constraints;
drop TABLE MDMADM.CI_MD_TBL_L cascade constraints;
drop TABLE MDMADM.CI_MD_TMPL cascade constraints;
drop TABLE MDMADM.CI_MD_TMPL_ELTY cascade constraints;
drop TABLE MDMADM.CI_MD_TMPL_L cascade constraints;
drop TABLE MDMADM.CI_MD_TMPL_VAR cascade constraints;
drop TABLE MDMADM.CI_MD_TMPL_VAR_L cascade constraints;
drop TABLE MDMADM.CI_MD_TOOLREP_XML cascade constraints;
drop TABLE MDMADM.CI_MD_TOOL_REP cascade constraints;
drop TABLE MDMADM.CI_MD_VAR cascade constraints;
drop TABLE MDMADM.CI_MD_VAR_DTL cascade constraints;
drop TABLE MDMADM.CI_MD_VAR_DTL_L cascade constraints;
drop TABLE MDMADM.CI_MD_WRK_TBL cascade constraints;
drop TABLE MDMADM.CI_MD_WRK_TBLFLD cascade constraints;
drop TABLE MDMADM.CI_MD_WRK_TBL_L cascade constraints;
drop TABLE MDMADM.CI_MSG cascade constraints;
drop TABLE MDMADM.CI_MSG_CATEGORY cascade constraints;
drop TABLE MDMADM.CI_MSG_CATEGORY_L cascade constraints;
drop TABLE MDMADM.CI_MSG_L cascade constraints;
drop TABLE MDMADM.CI_MSG_LOG cascade constraints;
drop TABLE MDMADM.CI_MSG_LOGPARM cascade constraints;
drop TABLE MDMADM.CI_MSG_LOG_PK cascade constraints;
drop TABLE MDMADM.CI_NAV_OPT cascade constraints;
drop TABLE MDMADM.CI_NAV_OPT_CTXT cascade constraints;
drop TABLE MDMADM.CI_NAV_OPT_L cascade constraints;
drop TABLE MDMADM.CI_NAV_OPT_USG cascade constraints;
drop TABLE MDMADM.CI_NT_DNTY_CTXT cascade constraints;
drop TABLE MDMADM.CI_NT_DWN cascade constraints;
drop TABLE MDMADM.CI_NT_DWN_CHAR cascade constraints;
drop TABLE MDMADM.CI_NT_DWN_CTXT cascade constraints;
drop TABLE MDMADM.CI_NT_DWN_EXC cascade constraints;
drop TABLE MDMADM.CI_NT_DWN_EXP cascade constraints;
drop TABLE MDMADM.CI_NT_DWN_FORM cascade constraints;
drop TABLE MDMADM.CI_NT_DWN_FORM_L cascade constraints;
drop TABLE MDMADM.CI_NT_DWN_PROF cascade constraints;
drop TABLE MDMADM.CI_NT_DWN_PROF_L cascade constraints;
drop TABLE MDMADM.CI_NT_DWN_TYPE cascade constraints;
drop TABLE MDMADM.CI_NT_DWN_TYPE_L cascade constraints;
drop TABLE MDMADM.CI_NT_UP cascade constraints;
drop TABLE MDMADM.CI_NT_UP_CHAR cascade constraints;
drop TABLE MDMADM.CI_NT_UP_CTXT cascade constraints;
drop TABLE MDMADM.CI_NT_UP_EXCP cascade constraints;
drop TABLE MDMADM.CI_NT_UP_XTYPE cascade constraints;
drop TABLE MDMADM.CI_NT_UP_XTYPE_L cascade constraints;
drop TABLE MDMADM.CI_NT_XID cascade constraints;
drop TABLE MDMADM.CI_NT_XID_L cascade constraints;
drop TABLE MDMADM.CI_PHONE_TYPE cascade constraints;
drop TABLE MDMADM.CI_PHONE_TYPE_L cascade constraints;
drop TABLE MDMADM.CI_PORTAL cascade constraints;
drop TABLE MDMADM.CI_PORTAL_L cascade constraints;
drop TABLE MDMADM.CI_PORTAL_ZONE cascade constraints;
drop TABLE MDMADM.CI_ROLE cascade constraints;
drop TABLE MDMADM.CI_ROLE_L cascade constraints;
drop TABLE MDMADM.CI_ROLE_USER cascade constraints;
drop TABLE MDMADM.CI_ROOT_DIFF cascade constraints;
drop TABLE MDMADM.CI_ROOT_INSTR cascade constraints;
drop TABLE MDMADM.CI_ROOT_OBJ cascade constraints;
drop TABLE MDMADM.CI_ROOT_OBJ_EXC cascade constraints;
drop TABLE MDMADM.CI_ROOT_OBJ_EXP cascade constraints;
drop TABLE MDMADM.CI_ROOT_OBJ_PK cascade constraints;
drop TABLE MDMADM.CI_RPT_OPTION cascade constraints;
drop TABLE MDMADM.CI_SCR cascade constraints;
drop TABLE MDMADM.CI_SCR_CRT cascade constraints;
drop TABLE MDMADM.CI_SCR_CRT_GRP cascade constraints;
drop TABLE MDMADM.CI_SCR_CRT_GRP_L cascade constraints;
drop TABLE MDMADM.CI_SCR_DA cascade constraints;
drop TABLE MDMADM.CI_SCR_FLD_MAP cascade constraints;
drop TABLE MDMADM.CI_SCR_L cascade constraints;
drop TABLE MDMADM.CI_SCR_PRMPT cascade constraints;
drop TABLE MDMADM.CI_SCR_PRMPT_L cascade constraints;
drop TABLE MDMADM.CI_SCR_STEP_L cascade constraints;
drop TABLE MDMADM.CI_SC_AUTH_LVL cascade constraints;
drop TABLE MDMADM.CI_SC_AUTH_LVL_L cascade constraints;
drop TABLE MDMADM.CI_SC_TYPE cascade constraints;
drop TABLE MDMADM.CI_SC_TYPE_L cascade constraints;
drop TABLE MDMADM.CI_SEAS_SHIFT cascade constraints;
drop TABLE MDMADM.CI_SEAS_TM_SHIFT cascade constraints;
drop TABLE MDMADM.CI_SEAS_TM_SHIFT_L cascade constraints;
drop TABLE MDMADM.CI_SEQ cascade constraints;
drop TABLE MDMADM.CI_STATE cascade constraints;
drop TABLE MDMADM.CI_STATE_L cascade constraints;
drop TABLE MDMADM.CI_SYSDATA_LOG cascade constraints;
drop TABLE MDMADM.CI_TD_DRLKEY cascade constraints;
drop TABLE MDMADM.CI_TD_DRLKEY_TY cascade constraints;
drop TABLE MDMADM.CI_TD_ENTRY cascade constraints;
drop TABLE MDMADM.CI_TD_ENTRY_CHA cascade constraints;
drop TABLE MDMADM.CI_TD_EX_LIST cascade constraints;
drop TABLE MDMADM.CI_TD_LOG cascade constraints;
drop TABLE MDMADM.CI_TD_MSG_PARM cascade constraints;
drop TABLE MDMADM.CI_TD_SRTKEY cascade constraints;
drop TABLE MDMADM.CI_TD_SRTKEY_TY cascade constraints;
drop TABLE MDMADM.CI_TD_SRTKEY_TY_L cascade constraints;
drop TABLE MDMADM.CI_TD_TYPE cascade constraints;
drop TABLE MDMADM.CI_TD_TYPE_ALG cascade constraints;
drop TABLE MDMADM.CI_TD_TYPE_CHAR cascade constraints;
drop TABLE MDMADM.CI_TD_TYPE_L cascade constraints;
drop TABLE MDMADM.CI_TD_VAL_ROLE cascade constraints;
drop TABLE MDMADM.CI_TIME_ZONE cascade constraints;
drop TABLE MDMADM.CI_TIME_ZONE_L cascade constraints;
drop TABLE MDMADM.CI_UI_ZONE cascade constraints;
drop TABLE MDMADM.CI_USR_GRP_SC cascade constraints;
drop TABLE MDMADM.CI_USR_NAV_LINK cascade constraints;
drop TABLE MDMADM.CI_USR_PORTAL cascade constraints;
drop TABLE MDMADM.CI_USR_SCR cascade constraints;
drop TABLE MDMADM.CI_VAL_ERR cascade constraints;
drop TABLE MDMADM.CI_VAL_FK_ERR cascade constraints;
drop TABLE MDMADM.CI_WFM cascade constraints;
drop TABLE MDMADM.CI_WFM_L cascade constraints;
drop TABLE MDMADM.CI_WFM_MSG cascade constraints;
drop TABLE MDMADM.CI_WFM_OPT cascade constraints;
drop TABLE MDMADM.CI_WF_EVT cascade constraints;
drop TABLE MDMADM.CI_WF_EVT_CHAR cascade constraints;
drop TABLE MDMADM.CI_WF_EVT_CTXT cascade constraints;
drop TABLE MDMADM.CI_WF_EVT_DEP cascade constraints;
drop TABLE MDMADM.CI_WF_EVT_EXC cascade constraints;
drop TABLE MDMADM.CI_WF_EVT_EXP cascade constraints;
drop TABLE MDMADM.CI_WF_EVT_TYPE cascade constraints;
drop TABLE MDMADM.CI_WF_EVT_TYPE_L cascade constraints;
drop TABLE MDMADM.CI_WF_PP cascade constraints;
drop TABLE MDMADM.CI_WF_PP_L cascade constraints;
drop TABLE MDMADM.CI_WF_PP_NT cascade constraints;
drop TABLE MDMADM.CI_WF_PP_NT_CRT cascade constraints;
drop TABLE MDMADM.CI_WF_PROC cascade constraints;
drop TABLE MDMADM.CI_WF_PROC_CHAR cascade constraints;
drop TABLE MDMADM.CI_WF_PROC_CTXT cascade constraints;
drop TABLE MDMADM.CI_WF_PROC_MSGP cascade constraints;
drop TABLE MDMADM.CI_WF_PROC_SCHED cascade constraints;
drop TABLE MDMADM.CI_WF_PROC_TMPL cascade constraints;
drop TABLE MDMADM.CI_WF_PROC_TMPL_L cascade constraints;
drop TABLE MDMADM.CI_WF_RESP cascade constraints;
drop TABLE MDMADM.CI_WF_RESP_DEP cascade constraints;
drop TABLE MDMADM.CI_XAI_ADAPTER cascade constraints;
drop TABLE MDMADM.CI_XAI_ADAPTER_L cascade constraints;
drop TABLE MDMADM.CI_XAI_CLASS cascade constraints;
drop TABLE MDMADM.CI_XAI_CLASS_L cascade constraints;
drop TABLE MDMADM.CI_XAI_DWN_EXC cascade constraints;
drop TABLE MDMADM.CI_XAI_DWN_EXP cascade constraints;
drop TABLE MDMADM.CI_XAI_ENV_HNDL cascade constraints;
drop TABLE MDMADM.CI_XAI_ENV_HNDL_L cascade constraints;
drop TABLE MDMADM.CI_XAI_EXECUTER cascade constraints;
drop TABLE MDMADM.CI_XAI_EXECUTER_L cascade constraints;
drop TABLE MDMADM.CI_XAI_FORMAT cascade constraints;
drop TABLE MDMADM.CI_XAI_FORMAT_L cascade constraints;
drop TABLE MDMADM.CI_XAI_IN_SVC cascade constraints;
drop TABLE MDMADM.CI_XAI_IN_SVC_L cascade constraints;
drop TABLE MDMADM.CI_XAI_JDBC_CON cascade constraints;
drop TABLE MDMADM.CI_XAI_JDBC_CON_L cascade constraints;
drop TABLE MDMADM.CI_XAI_JMS_CON cascade constraints;
drop TABLE MDMADM.CI_XAI_JMS_CON_L cascade constraints;
drop TABLE MDMADM.CI_XAI_JMS_Q cascade constraints;
drop TABLE MDMADM.CI_XAI_JMS_Q_L cascade constraints;
drop TABLE MDMADM.CI_XAI_JMS_TPC cascade constraints;
drop TABLE MDMADM.CI_XAI_JMS_TPC_L cascade constraints;
drop TABLE MDMADM.CI_XAI_JNDI_SVR cascade constraints;
drop TABLE MDMADM.CI_XAI_JNDI_SVR_L cascade constraints;
drop TABLE MDMADM.CI_XAI_OPTION cascade constraints;
drop TABLE MDMADM.CI_XAI_RCVR cascade constraints;
drop TABLE MDMADM.CI_XAI_RCVR_CTX cascade constraints;
drop TABLE MDMADM.CI_XAI_RCVR_L cascade constraints;
drop TABLE MDMADM.CI_XAI_RCVR_RGRP cascade constraints;
drop TABLE MDMADM.CI_XAI_RCVR_RSP cascade constraints;
drop TABLE MDMADM.CI_XAI_RGRP cascade constraints;
drop TABLE MDMADM.CI_XAI_RGRP_ATT cascade constraints;
drop TABLE MDMADM.CI_XAI_RGRP_L cascade constraints;
drop TABLE MDMADM.CI_XAI_ROUTING cascade constraints;
drop TABLE MDMADM.CI_XAI_RT_TYPE cascade constraints;
drop TABLE MDMADM.CI_XAI_RT_TYPE_L cascade constraints;
drop TABLE MDMADM.CI_XAI_RULE cascade constraints;
drop TABLE MDMADM.CI_XAI_SENDER cascade constraints;
drop TABLE MDMADM.CI_XAI_SENDER_L cascade constraints;
drop TABLE MDMADM.CI_XAI_SNDR_CTX cascade constraints;
drop TABLE MDMADM.CI_XAI_SVC_PARM cascade constraints;
drop TABLE MDMADM.CI_XML_STGCTL_P cascade constraints;
drop TABLE MDMADM.CI_XML_STGUPEXP cascade constraints;
drop TABLE MDMADM.CI_XML_STGUP_EX cascade constraints;
drop TABLE MDMADM.CI_XML_STG_CTL cascade constraints;
drop TABLE MDMADM.CI_ZONE cascade constraints;
drop TABLE MDMADM.CI_ZONE_HDL cascade constraints;
drop TABLE MDMADM.CI_ZONE_HDL_L cascade constraints;
drop TABLE MDMADM.CI_ZONE_HDL_PRM cascade constraints;
drop TABLE MDMADM.CI_ZONE_HDL_PRM_L cascade constraints;
drop TABLE MDMADM.CI_ZONE_L cascade constraints;
drop TABLE MDMADM.CI_ZONE_PRM cascade constraints;
drop TABLE MDMADM.F1_ATTACHMENT_CHAR cascade constraints;
drop TABLE MDMADM.F1_BNDL_CHAR cascade constraints;
drop TABLE MDMADM.F1_BNDL_ENTITY cascade constraints;
drop TABLE MDMADM.F1_BNDL_LOG cascade constraints;
drop TABLE MDMADM.F1_BNDL_LOG_PARM cascade constraints;
drop TABLE MDMADM.F1_BUS_EVT_LOG_CHAR cascade constraints;
drop TABLE MDMADM.F1_BUS_EVT_LOG_MSG_PARM cascade constraints;
drop TABLE MDMADM.F1_BUS_OBJ cascade constraints;
drop TABLE MDMADM.F1_BUS_OBJ_ALG cascade constraints;
drop TABLE MDMADM.F1_BUS_OBJ_L cascade constraints;
drop TABLE MDMADM.F1_BUS_OBJ_OPT cascade constraints;
drop TABLE MDMADM.F1_BUS_OBJ_STATUS cascade constraints;
drop TABLE MDMADM.F1_BUS_OBJ_STATUS_ALG cascade constraints;
drop TABLE MDMADM.F1_BUS_OBJ_STATUS_L cascade constraints;
drop TABLE MDMADM.F1_BUS_OBJ_STATUS_OPT cascade constraints;
drop TABLE MDMADM.F1_BUS_OBJ_STATUS_RSN_CHAR cascade constraints;
drop TABLE MDMADM.F1_BUS_OBJ_STATUS_RSN_L cascade constraints;
drop TABLE MDMADM.F1_BUS_OBJ_TR_RULE cascade constraints;
drop TABLE MDMADM.F1_BUS_OBJ_TR_RULE_L cascade constraints;
drop TABLE MDMADM.F1_BUS_SVC cascade constraints;
drop TABLE MDMADM.F1_BUS_SVC_L cascade constraints;
drop TABLE MDMADM.F1_DATA_AREA cascade constraints;
drop TABLE MDMADM.F1_DATA_AREA_L cascade constraints;
drop TABLE MDMADM.F1_DB_OBJECTS_REPO cascade constraints;
drop TABLE MDMADM.F1_EXTSYS_OUTMSG_PROF cascade constraints;
drop TABLE MDMADM.F1_EXT_LOOKUP_VAL_L cascade constraints;
drop TABLE MDMADM.F1_FACT_CHAR cascade constraints;
drop TABLE MDMADM.F1_FACT_LOG cascade constraints;
drop TABLE MDMADM.F1_FACT_LOG_PARM cascade constraints;
drop TABLE MDMADM.F1_GEN_PROC cascade constraints;
drop TABLE MDMADM.F1_INSTALLATION cascade constraints;
drop TABLE MDMADM.F1_MANAG_CONTENT_L cascade constraints;
drop TABLE MDMADM.F1_MAP_L cascade constraints;
drop TABLE MDMADM.F1_MD_DB_OBJ cascade constraints;
drop TABLE MDMADM.F1_MIGR_DATA_ST cascade constraints;
drop TABLE MDMADM.F1_MIGR_DATA_ST_ALG cascade constraints;
drop TABLE MDMADM.F1_MIGR_DATA_ST_LOG cascade constraints;
drop TABLE MDMADM.F1_MIGR_DATA_ST_LOG_PARM cascade constraints;
drop TABLE MDMADM.F1_MIGR_OBJ_ALG cascade constraints;
drop TABLE MDMADM.F1_MIGR_OBJ_LOG cascade constraints;
drop TABLE MDMADM.F1_MIGR_OBJ_LOG_PARM cascade constraints;
drop TABLE MDMADM.F1_MIGR_OBJ_SQL cascade constraints;
drop TABLE MDMADM.F1_MIGR_PLAN cascade constraints;
drop TABLE MDMADM.F1_MIGR_PLAN_INSTR cascade constraints;
drop TABLE MDMADM.F1_MIGR_PLAN_INSTR_ALG cascade constraints;
drop TABLE MDMADM.F1_MIGR_PLAN_INSTR_L cascade constraints;
drop TABLE MDMADM.F1_MIGR_PLAN_L cascade constraints;
drop TABLE MDMADM.F1_MIGR_REQ cascade constraints;
drop TABLE MDMADM.F1_MIGR_REQ_INSTR cascade constraints;
drop TABLE MDMADM.F1_MIGR_REQ_INSTR_ENTITY cascade constraints;
drop TABLE MDMADM.F1_MIGR_REQ_INSTR_L cascade constraints;
drop TABLE MDMADM.F1_MIGR_REQ_L cascade constraints;
drop TABLE MDMADM.F1_MIGR_TRANS cascade constraints;
drop TABLE MDMADM.F1_MIGR_TRANS_LOG cascade constraints;
drop TABLE MDMADM.F1_MIGR_TRANS_LOG_PARM cascade constraints;
drop TABLE MDMADM.F1_OBJ_REV_CHAR cascade constraints;
drop TABLE MDMADM.F1_OBJ_REV_LOG cascade constraints;
drop TABLE MDMADM.F1_OBJ_REV_LOG_PARM cascade constraints;
drop TABLE MDMADM.F1_OUTMSG_ERRPARM cascade constraints;
drop TABLE MDMADM.F1_OUTMSG_TYPE cascade constraints;
drop TABLE MDMADM.F1_OUTMSG_TYPE_L cascade constraints;
drop TABLE MDMADM.F1_REQ_LOG cascade constraints;
drop TABLE MDMADM.F1_REQ_LOG_PARM cascade constraints;
drop TABLE MDMADM.F1_REQ_TYPE_L cascade constraints;
drop TABLE MDMADM.F1_REQ_TYPE_LOG cascade constraints;
drop TABLE MDMADM.F1_REQ_TYPE_LOG_PARM cascade constraints;
drop TABLE MDMADM.F1_SVC_TASK_CHAR cascade constraints;
drop TABLE MDMADM.F1_SVC_TASK_LOG cascade constraints;
drop TABLE MDMADM.F1_SVC_TASK_LOG_PARM cascade constraints;
drop TABLE MDMADM.F1_SVC_TASK_REL_OBJ cascade constraints;
drop TABLE MDMADM.F1_SVC_TASK_TYPE_CHAR cascade constraints;
drop TABLE MDMADM.F1_SVC_TASK_TYPE_L cascade constraints;
drop TABLE MDMADM.F1_SYNC_REQ_CHAR cascade constraints;
drop TABLE MDMADM.F1_SYNC_REQ_EXTRACT cascade constraints;
drop TABLE MDMADM.F1_SYNC_REQ_IN_CHAR cascade constraints;
drop TABLE MDMADM.F1_SYNC_REQ_IN_EXCP cascade constraints;
drop TABLE MDMADM.F1_SYNC_REQ_IN_EXCP_PARM cascade constraints;
drop TABLE MDMADM.F1_SYNC_REQ_IN_LOG cascade constraints;
drop TABLE MDMADM.F1_SYNC_REQ_IN_LOG_PARM cascade constraints;
drop TABLE MDMADM.F1_SYNC_REQ_IN_REL_OBJ cascade constraints;
drop TABLE MDMADM.F1_SYNC_REQ_LOG cascade constraints;
drop TABLE MDMADM.F1_SYNC_REQ_LOG_PARM cascade constraints;
drop TABLE MDMADM.F1_WEB_SVC_CHAR cascade constraints;
drop TABLE MDMADM.F1_WEB_SVC_L cascade constraints;
drop TABLE MDMADM.F1_WEB_SVC_LOG cascade constraints;
drop TABLE MDMADM.F1_WEB_SVC_LOG_PARM cascade constraints;
drop TABLE MDMADM.F1_WEB_SVC_OPERATIONS cascade constraints;
drop TABLE MDMADM.SC_ACCESS_CNTL cascade constraints;
drop TABLE MDMADM.SC_APP_SERVICE cascade constraints;
drop TABLE MDMADM.SC_APP_SERVICE_L cascade constraints;
drop TABLE MDMADM.SC_USER cascade constraints;
drop TABLE MDMADM.SC_USER_CHAR cascade constraints;
drop TABLE MDMADM.SC_USER_GROUP cascade constraints;
drop TABLE MDMADM.SC_USER_GROUP_L cascade constraints;
drop TABLE MDMADM.SC_USR_GRP_PROF cascade constraints;
drop TABLE MDMADM.SC_USR_GRP_USR cascade constraints;
drop TABLE MDMADM.D1_OBIEE_EVENT_POLLING cascade constraints;
drop TABLE MDMADM.D1_ACTIVITY_CHAR cascade constraints;
drop TABLE MDMADM.D1_ACTIVITY_IDENTIFIER cascade constraints;
drop TABLE MDMADM.D1_ACTIVITY_LOG cascade constraints;
drop TABLE MDMADM.D1_ACTIVITY_LOG_PARM cascade constraints;
drop TABLE MDMADM.D1_ACTIVITY_REL cascade constraints;
drop TABLE MDMADM.D1_ACTIVITY_REL_OBJ cascade constraints;
drop TABLE MDMADM.D1_ACTIVITY_TYPE_CHAR cascade constraints;
drop TABLE MDMADM.D1_ACTIVITY_TYPE_L cascade constraints;
drop TABLE MDMADM.D1_COMM_IN_CHAR cascade constraints;
drop TABLE MDMADM.D1_COMM_IN_IDENTIFIER cascade constraints;
drop TABLE MDMADM.D1_COMM_IN_LOG cascade constraints;
drop TABLE MDMADM.D1_COMM_IN_LOG_PARM cascade constraints;
drop TABLE MDMADM.D1_COMM_IN_REL_OBJ cascade constraints;
drop TABLE MDMADM.D1_COMM_OUT_CHAR cascade constraints;
drop TABLE MDMADM.D1_COMM_OUT_IDENTIFIER cascade constraints;
drop TABLE MDMADM.D1_COMM_OUT_LOG cascade constraints;
drop TABLE MDMADM.D1_COMM_OUT_LOG_PARM cascade constraints;
drop TABLE MDMADM.D1_COMM_OUT_REL_OBJ cascade constraints;
drop TABLE MDMADM.D1_COMM_TYPE_CHAR cascade constraints;
drop TABLE MDMADM.D1_COMM_TYPE_L cascade constraints;
drop TABLE MDMADM.D1_COMPL_EVT_CHAR cascade constraints;
drop TABLE MDMADM.D1_COMPL_EVT_LOG cascade constraints;
drop TABLE MDMADM.D1_COMPL_EVT_LOG_PARM cascade constraints;
drop TABLE MDMADM.D1_COMPL_EVT_REL_OBJ cascade constraints;
drop TABLE MDMADM.D1_CONTACT_CHAR cascade constraints;
drop TABLE MDMADM.D1_CONTACT_EMAIL cascade constraints;
drop TABLE MDMADM.D1_CONTACT_IDENTIFIER cascade constraints;
drop TABLE MDMADM.D1_CONTACT_NAME cascade constraints;
drop TABLE MDMADM.D1_CONTACT_PHONE cascade constraints;
drop TABLE MDMADM.D1_CONTACT_TYPE_CHAR cascade constraints;
drop TABLE MDMADM.D1_CONTACT_TYPE_L cascade constraints;
drop TABLE MDMADM.D1_DVC_CFG_CHAR cascade constraints;
drop TABLE MDMADM.D1_DVC_CFG_LOG cascade constraints;
drop TABLE MDMADM.D1_DVC_CFG_LOG_PARM cascade constraints;
drop TABLE MDMADM.D1_DVC_CFG_TYPE_CHAR cascade constraints;
drop TABLE MDMADM.D1_DVC_CFG_TYPE_L cascade constraints;
drop TABLE MDMADM.D1_DVC_CFG_TYPE_MC_TYPE cascade constraints;
drop TABLE MDMADM.D1_DVC_CHAR cascade constraints;
drop TABLE MDMADM.D1_DVC_EVT_CHAR cascade constraints;
drop TABLE MDMADM.D1_DVC_EVT_IDENTIFIER cascade constraints;
drop TABLE MDMADM.D1_DVC_EVT_LOG cascade constraints;
drop TABLE MDMADM.D1_DVC_EVT_LOG_PARM cascade constraints;
drop TABLE MDMADM.D1_DVC_EVT_REL_OBJ cascade constraints;
drop TABLE MDMADM.D1_DVC_EVT_TYPE_CHAR cascade constraints;
drop TABLE MDMADM.D1_DVC_EVT_TYPE_L cascade constraints;
drop TABLE MDMADM.D1_DVC_IDENTIFIER cascade constraints;
drop TABLE MDMADM.D1_DVC_LOG cascade constraints;
drop TABLE MDMADM.D1_DVC_LOG_PARM cascade constraints;
drop TABLE MDMADM.D1_DVC_TYPE_CFG_TYPE cascade constraints;
drop TABLE MDMADM.D1_DVC_TYPE_CHAR cascade constraints;
drop TABLE MDMADM.D1_DVC_TYPE_L cascade constraints;
drop TABLE MDMADM.D1_DVC_TYPE_SPR cascade constraints;
drop TABLE MDMADM.D1_DYN_OPT_CHAR cascade constraints;
drop TABLE MDMADM.D1_DYN_OPT_EVENT_CHAR cascade constraints;
drop TABLE MDMADM.D1_DYN_OPT_EVENT_LOG cascade constraints;
drop TABLE MDMADM.D1_DYN_OPT_EVENT_LOG_PARM cascade constraints;
drop TABLE MDMADM.D1_DYN_OPT_L cascade constraints;
drop TABLE MDMADM.D1_DYN_OPT_LOG cascade constraints;
drop TABLE MDMADM.D1_DYN_OPT_LOG_PARM cascade constraints;
drop TABLE MDMADM.D1_DYN_OPT_TYPE_CHAR cascade constraints;
drop TABLE MDMADM.D1_DYN_OPT_TYPE_L cascade constraints;
drop TABLE MDMADM.D1_EXCP_TYPE_CHAR cascade constraints;
drop TABLE MDMADM.D1_EXCP_TYPE_L cascade constraints;
drop TABLE MDMADM.D1_FACTOR_CHAR cascade constraints;
drop TABLE MDMADM.D1_FACTOR_CHAR_VALUE cascade constraints;
drop TABLE MDMADM.D1_FACTOR_L cascade constraints;
drop TABLE MDMADM.D1_FACTOR_VALUE cascade constraints;
drop TABLE MDMADM.D1_FACTOR_VALUE_CHAR cascade constraints;
drop TABLE MDMADM.D1_IMD_CTRL cascade constraints;
drop TABLE MDMADM.D1_INIT_MSRMT_DATA_CHAR cascade constraints;
drop TABLE MDMADM.D1_INIT_MSRMT_DATA_LOG cascade constraints;
drop TABLE MDMADM.D1_INIT_MSRMT_DATA_LOG_PARM cascade constraints;
drop TABLE MDMADM.D1_INSTALL_EVT_CHAR cascade constraints;
drop TABLE MDMADM.D1_INSTALL_EVT_LOG cascade constraints;
drop TABLE MDMADM.D1_INSTALL_EVT_LOG_PARM cascade constraints;
drop TABLE MDMADM.D1_MANUFACTURER_L cascade constraints;
drop TABLE MDMADM.D1_MC_TYPE_VALUE_IDENTIFIER cascade constraints;
drop TABLE MDMADM.D1_MC_TYPE_VALUE_IDENTIFIER_L cascade constraints;
drop TABLE MDMADM.D1_MEASR_COMP_CHAR cascade constraints;
drop TABLE MDMADM.D1_MEASR_COMP_IDENTIFIER cascade constraints;
drop TABLE MDMADM.D1_MEASR_COMP_LOG cascade constraints;
drop TABLE MDMADM.D1_MEASR_COMP_LOG_PARM cascade constraints;
drop TABLE MDMADM.D1_MEASR_COMP_REL cascade constraints;
drop TABLE MDMADM.D1_MEASR_COMP_TYPE_CHAR cascade constraints;
drop TABLE MDMADM.D1_MEASR_COMP_TYPE_L cascade constraints;
drop TABLE MDMADM.D1_MEASR_COMP_TYPE_VEE_GRP cascade constraints;
drop TABLE MDMADM.D1_MEASR_COMP_TYP_FBK_VEE_GRP cascade constraints;
drop TABLE MDMADM.D1_MEASR_COMP_VEE_GROUP cascade constraints;
drop TABLE MDMADM.D1_MKT_CHAR cascade constraints;
drop TABLE MDMADM.D1_MKT_FALLBACK_SPR cascade constraints;
drop TABLE MDMADM.D1_MKT_L cascade constraints;
drop TABLE MDMADM.D1_MKT_REL_TYPE cascade constraints;
drop TABLE MDMADM.D1_MKT_VALID_SPR cascade constraints;
drop TABLE MDMADM.D1_MODEL_L cascade constraints;
drop TABLE MDMADM.D1_MSRMT cascade constraints;
drop TABLE MDMADM.D1_MSRMT_CHAR cascade constraints;
drop TABLE MDMADM.D1_MSRMT_CYC_CHAR cascade constraints;
drop TABLE MDMADM.D1_MSRMT_CYC_L cascade constraints;
drop TABLE MDMADM.D1_MSRMT_CYC_MCR cascade constraints;
drop TABLE MDMADM.D1_MSRMT_CYC_RTE_CHAR cascade constraints;
drop TABLE MDMADM.D1_MSRMT_CYC_RTE_L cascade constraints;
drop TABLE MDMADM.D1_MSRMT_CYC_SCHED_CHAR cascade constraints;
drop TABLE MDMADM.D1_MSRMT_CYC_SCHED_RTE cascade constraints;
drop TABLE MDMADM.D1_MSRMT_LOG_PARM cascade constraints;
drop TABLE MDMADM.D1_PROC_MTHD_CHAR cascade constraints;
drop TABLE MDMADM.D1_PROC_MTHD_L cascade constraints;
drop TABLE MDMADM.D1_SPR_CHAR cascade constraints;
drop TABLE MDMADM.D1_SPR_L cascade constraints;
drop TABLE MDMADM.D1_SP_CHAR cascade constraints;
drop TABLE MDMADM.D1_SP_CONTACT cascade constraints;
drop TABLE MDMADM.D1_SP_IDENTIFIER cascade constraints;
drop TABLE MDMADM.D1_SP_LOG cascade constraints;
drop TABLE MDMADM.D1_SP_LOG_PARM cascade constraints;
drop TABLE MDMADM.D1_SP_MKT_PARTICIPANT cascade constraints;
drop TABLE MDMADM.D1_SP_MSRMT_CYC_SCHED_RTE cascade constraints;
drop TABLE MDMADM.D1_SP_REL cascade constraints;
drop TABLE MDMADM.D1_SP_TYPE_CHAR cascade constraints;
drop TABLE MDMADM.D1_SP_TYPE_DEVICE_TYPE cascade constraints;
drop TABLE MDMADM.D1_SP_TYPE_L cascade constraints;
drop TABLE MDMADM.D1_SQI_L cascade constraints;
drop TABLE MDMADM.D1_SVC_TYPE_L cascade constraints;
drop TABLE MDMADM.D1_TOU_GRP_CHAR cascade constraints;
drop TABLE MDMADM.D1_TOU_GRP_L cascade constraints;
drop TABLE MDMADM.D1_TOU_GRP_TOU cascade constraints;
drop TABLE MDMADM.D1_TOU_L cascade constraints;
drop TABLE MDMADM.D1_TOU_MAP_CHAR cascade constraints;
drop TABLE MDMADM.D1_TOU_MAP_DATA cascade constraints;
drop TABLE MDMADM.D1_TOU_MAP_DATA_CHAR cascade constraints;
drop TABLE MDMADM.D1_TOU_MAP_DYN_OPT cascade constraints;
drop TABLE MDMADM.D1_TOU_MAP_L cascade constraints;
drop TABLE MDMADM.D1_TOU_MAP_LOG cascade constraints;
drop TABLE MDMADM.D1_TOU_MAP_LOG_PARM cascade constraints;
drop TABLE MDMADM.D1_TOU_MAP_TMPLT_CHAR cascade constraints;
drop TABLE MDMADM.D1_TOU_MAP_TMPLT_L cascade constraints;
drop TABLE MDMADM.D1_TOU_MAP_TYPE_CHAR cascade constraints;
drop TABLE MDMADM.D1_TOU_MAP_TYPE_L cascade constraints;
drop TABLE MDMADM.D1_TOU_MAP_TYPE_TMPLT cascade constraints;
drop TABLE MDMADM.D1_UOM_L cascade constraints;
drop TABLE MDMADM.D1_USAGE_CHAR cascade constraints;
drop TABLE MDMADM.D1_USAGE_LOG cascade constraints;
drop TABLE MDMADM.D1_USAGE_LOG_PARM cascade constraints;
drop TABLE MDMADM.D1_USAGE_REL cascade constraints;
drop TABLE MDMADM.D1_USG_GRP_CHAR cascade constraints;
drop TABLE MDMADM.D1_USG_GRP_L cascade constraints;
drop TABLE MDMADM.D1_USG_GRP_VAL_DC_TYPE cascade constraints;
drop TABLE MDMADM.D1_USG_RULE_CHAR cascade constraints;
drop TABLE MDMADM.D1_USG_RULE_ELIG_CRIT_CHAR cascade constraints;
drop TABLE MDMADM.D1_USG_RULE_ELIG_CRIT_L cascade constraints;
drop TABLE MDMADM.D1_USG_RULE_L cascade constraints;
drop TABLE MDMADM.D1_US_CHAR cascade constraints;
drop TABLE MDMADM.D1_US_CONTACT cascade constraints;
drop TABLE MDMADM.D1_US_FACTOR_OVRD cascade constraints;
drop TABLE MDMADM.D1_US_IDENTIFIER cascade constraints;
drop TABLE MDMADM.D1_US_LOG cascade constraints;
drop TABLE MDMADM.D1_US_LOG_PARM cascade constraints;
drop TABLE MDMADM.D1_US_REL cascade constraints;
drop TABLE MDMADM.D1_US_SP_CHAR cascade constraints;
drop TABLE MDMADM.D1_US_TYPE_CHAR cascade constraints;
drop TABLE MDMADM.D1_US_TYPE_FB_USG_GRP cascade constraints;
drop TABLE MDMADM.D1_US_TYPE_L cascade constraints;
drop TABLE MDMADM.D1_US_TYPE_VAL_DYN_OPT_TYPE cascade constraints;
drop TABLE MDMADM.D1_US_TYPE_VAL_SPR cascade constraints;
drop TABLE MDMADM.D1_US_TYPE_VAL_SP_TYPE cascade constraints;
drop TABLE MDMADM.D1_US_TYPE_VAL_USG_GRP cascade constraints;
drop TABLE MDMADM.D1_US_USG_GRP cascade constraints;
drop TABLE MDMADM.D1_VEE_ELIG_CRIT_CHAR cascade constraints;
drop TABLE MDMADM.D1_VEE_ELIG_CRIT_L cascade constraints;
drop TABLE MDMADM.D1_VEE_EXCP_CHAR cascade constraints;
drop TABLE MDMADM.D1_VEE_EXCP_PARM cascade constraints;
drop TABLE MDMADM.D1_VEE_GRP_CHAR cascade constraints;
drop TABLE MDMADM.D1_VEE_GRP_L cascade constraints;
drop TABLE MDMADM.D1_VEE_RULE_CHAR cascade constraints;
drop TABLE MDMADM.D1_VEE_RULE_L cascade constraints;
drop TABLE MDMADM.F1_BKT_CONFIG_L cascade constraints;
drop TABLE MDMADM.F1_BKT_CONFIG_REL_OBJ cascade constraints;
drop TABLE MDMADM.F1_BKT_CONFIG_VAL_L cascade constraints;
drop TABLE CCBADM.CI_MPL_EXC cascade constraints;
drop TABLE CCBADM.CI_SCR_STEP cascade constraints;
drop TABLE CCBADM.CI_USR_ZONE cascade constraints;
drop TABLE CCBADM.CI_XAI_DWN cascade constraints;
drop TABLE CCBADM.CI_XML_STGUP cascade constraints;
drop TABLE CCBADM.F1_ATTACHMENT cascade constraints;
drop TABLE CCBADM.F1_BNDL cascade constraints;
drop TABLE CCBADM.F1_BUS_EVT_LOG cascade constraints;
drop TABLE CCBADM.F1_BUS_OBJ_STATUS_RSN cascade constraints;
drop TABLE CCBADM.F1_EXT_LOOKUP_VAL cascade constraints;
drop TABLE CCBADM.F1_FACT cascade constraints;
drop TABLE CCBADM.F1_GENERIC_GTT cascade constraints;
drop TABLE CCBADM.F1_MANAG_CONTENT cascade constraints;
drop TABLE CCBADM.F1_MAP cascade constraints;
drop TABLE CCBADM.F1_MIGR_DATA_ST_TBL cascade constraints;
drop TABLE CCBADM.F1_MIGR_OBJ cascade constraints;
drop TABLE CCBADM.F1_MIGR_OBJ_CLOB cascade constraints;
drop TABLE CCBADM.F1_MST_CONFIG cascade constraints;
drop TABLE CCBADM.F1_OBJ_REV cascade constraints;
drop TABLE CCBADM.F1_OUTMSG cascade constraints;
drop TABLE CCBADM.F1_REQ cascade constraints;
drop TABLE CCBADM.F1_REQ_TYPE cascade constraints;
drop TABLE CCBADM.F1_SCHEMA cascade constraints;
drop TABLE CCBADM.F1_SVC_TASK cascade constraints;
drop TABLE CCBADM.F1_SVC_TASK_TYPE cascade constraints;
drop TABLE CCBADM.F1_SYNC_REQ cascade constraints;
drop TABLE CCBADM.F1_SYNC_REQ_IN cascade constraints;
drop TABLE CCBADM.F1_TSPACE_ENTRY cascade constraints;
drop TABLE CCBADM.F1_WEB_SVC cascade constraints;
drop TABLE CCBADM.F1_WEB_SVC_GTT cascade constraints;
drop TABLE CCBADM.C1_CALC_GRP cascade constraints;
drop TABLE CCBADM.C1_CALC_RULE cascade constraints;
drop TABLE CCBADM.C1_CALC_RULE_CRT cascade constraints;
drop TABLE CCBADM.C1_CL_CAT_TYPE cascade constraints;
drop TABLE CCBADM.C1_INITIATIVE cascade constraints;
drop TABLE CCBADM.C1_INITIATIVE_LEAD_CRIT cascade constraints;
drop TABLE CCBADM.C1_INITIATIVE_PRTC_CRIT cascade constraints;
drop TABLE CCBADM.C1_INTV_DATA_GTT cascade constraints;
drop TABLE CCBADM.C1_ISS_CTR cascade constraints;
drop TABLE CCBADM.C1_LEAD cascade constraints;
drop TABLE CCBADM.C1_LEAD_EVT cascade constraints;
drop TABLE CCBADM.C1_LEAD_EVT_TYPE cascade constraints;
drop TABLE CCBADM.C1_OFFCYC_BGEN cascade constraints;
drop TABLE CCBADM.C1_RC_CALC_GTT cascade constraints;
drop TABLE CCBADM.C1_RC_CALC_LN_GTT cascade constraints;
drop TABLE CCBADM.C1_RC_CHAR_GTT cascade constraints;
drop TABLE CCBADM.C1_RC_READ_GTT cascade constraints;
drop TABLE CCBADM.C1_RC_SQ_GTT cascade constraints;
drop TABLE CCBADM.C1_RC_TRACE_GTT cascade constraints;
drop TABLE CCBADM.C1_TOU_MAP cascade constraints;
drop TABLE CCBADM.C1_TOU_MAP_TMPLT cascade constraints;
drop TABLE CCBADM.C1_TOU_MAP_TYPE cascade constraints;
drop TABLE CCBADM.C1_USAGE cascade constraints;
drop TABLE CCBADM.CI_ACCT cascade constraints;
drop TABLE CCBADM.CI_ADJ cascade constraints;
drop TABLE CCBADM.CI_AM_ACTIVITY_TYPE cascade constraints;
drop TABLE CCBADM.CI_AM_REQ cascade constraints;
drop TABLE CCBADM.CI_APPR_PROF cascade constraints;
drop TABLE CCBADM.CI_APPR_REQ cascade constraints;
drop TABLE CCBADM.CI_BSEG cascade constraints;
drop TABLE CCBADM.CI_CASE cascade constraints;
drop TABLE CCBADM.CI_CC cascade constraints;
drop TABLE CCBADM.CI_CONSV_PROG cascade constraints;
drop TABLE CCBADM.CI_FA cascade constraints;
drop TABLE CCBADM.CI_INTV_DATA_SET cascade constraints;
drop TABLE CCBADM.CI_INTV_PF cascade constraints;
drop TABLE CCBADM.CI_INTV_PF_TYP cascade constraints;
drop TABLE CCBADM.CI_MKTMSG_TYPE cascade constraints;
drop TABLE CCBADM.CI_MR cascade constraints;
drop TABLE CCBADM.CI_MTR cascade constraints;
drop TABLE CCBADM.CI_MTR_CONFIG cascade constraints;
drop TABLE CCBADM.CI_PAY_TMPL cascade constraints;
drop TABLE CCBADM.CI_PER cascade constraints;
drop TABLE CCBADM.CI_PREM cascade constraints;
drop TABLE CCBADM.CI_REBATE_CLAIM cascade constraints;
drop TABLE CCBADM.CI_REBATE_DEFN cascade constraints;
drop TABLE CCBADM.CI_REBATE_LINE cascade constraints;
drop TABLE CCBADM.CI_SA cascade constraints;
drop TABLE CCBADM.CI_SP cascade constraints;
drop TABLE CCBADM.GTT_CLBDSYNC cascade constraints;
drop TABLE CCBADM.F1_BKT_CONFIG cascade constraints;
drop TABLE CCBADM.F1_BKT_CONFIG_VAL cascade constraints;
drop TABLE CCBADM.C1_INITIATIVE_CRITERIA cascade constraints;
drop TABLE CCBADM.C1_REPRESENTATIVE cascade constraints;
drop TABLE MDMADM.CI_MPL_EXC cascade constraints;
drop TABLE MDMADM.CI_SCR_STEP cascade constraints;
drop TABLE MDMADM.CI_USR_ZONE cascade constraints;
drop TABLE MDMADM.CI_XAI_DWN cascade constraints;
drop TABLE MDMADM.CI_XML_STGUP cascade constraints;
drop TABLE MDMADM.F1_ATTACHMENT cascade constraints;
drop TABLE MDMADM.F1_BNDL cascade constraints;
drop TABLE MDMADM.F1_BUS_EVT_LOG cascade constraints;
drop TABLE MDMADM.F1_BUS_OBJ_STATUS_RSN cascade constraints;
drop TABLE MDMADM.F1_EXT_LOOKUP_VAL cascade constraints;
drop TABLE MDMADM.F1_FACT cascade constraints;
drop TABLE MDMADM.F1_GENERIC_GTT cascade constraints;
drop TABLE MDMADM.F1_MANAG_CONTENT cascade constraints;
drop TABLE MDMADM.F1_MAP cascade constraints;
drop TABLE MDMADM.F1_MIGR_DATA_ST_TBL cascade constraints;
drop TABLE MDMADM.F1_MIGR_OBJ cascade constraints;
drop TABLE MDMADM.F1_MIGR_OBJ_CLOB cascade constraints;
drop TABLE MDMADM.F1_MST_CONFIG cascade constraints;
drop TABLE MDMADM.F1_OBJ_REV cascade constraints;
drop TABLE MDMADM.F1_OUTMSG cascade constraints;
drop TABLE MDMADM.F1_REQ cascade constraints;
drop TABLE MDMADM.F1_REQ_TYPE cascade constraints;
drop TABLE MDMADM.F1_SCHEMA cascade constraints;
drop TABLE MDMADM.F1_SVC_TASK cascade constraints;
drop TABLE MDMADM.F1_SVC_TASK_TYPE cascade constraints;
drop TABLE MDMADM.F1_SYNC_REQ cascade constraints;
drop TABLE MDMADM.F1_SYNC_REQ_IN cascade constraints;
drop TABLE MDMADM.F1_TSPACE_ENTRY cascade constraints;
drop TABLE MDMADM.F1_WEB_SVC cascade constraints;
drop TABLE MDMADM.F1_WEB_SVC_GTT cascade constraints;
drop TABLE MDMADM.D1_ACTIVITY cascade constraints;
drop TABLE MDMADM.D1_ACTIVITY_TYPE cascade constraints;
drop TABLE MDMADM.D1_COMM_IN cascade constraints;
drop TABLE MDMADM.D1_COMM_OUT cascade constraints;
drop TABLE MDMADM.D1_COMM_TYPE cascade constraints;
drop TABLE MDMADM.D1_COMPL_EVT cascade constraints;
drop TABLE MDMADM.D1_CONTACT cascade constraints;
drop TABLE MDMADM.D1_CONTACT_TYPE cascade constraints;
drop TABLE MDMADM.D1_DVC cascade constraints;
drop TABLE MDMADM.D1_DVC_CFG cascade constraints;
drop TABLE MDMADM.D1_DVC_CFG_TYPE cascade constraints;
drop TABLE MDMADM.D1_DVC_EVT cascade constraints;
drop TABLE MDMADM.D1_DVC_EVT_TYPE cascade constraints;
drop TABLE MDMADM.D1_DVC_TYPE cascade constraints;
drop TABLE MDMADM.D1_DYN_OPT cascade constraints;
drop TABLE MDMADM.D1_DYN_OPT_EVENT cascade constraints;
drop TABLE MDMADM.D1_DYN_OPT_TYPE cascade constraints;
drop TABLE MDMADM.D1_EXCP_TYPE cascade constraints;
drop TABLE MDMADM.D1_FACTOR cascade constraints;
drop TABLE MDMADM.D1_GTT1 cascade constraints;
drop TABLE MDMADM.D1_GTT2 cascade constraints;
drop TABLE MDMADM.D1_INIT_MSRMT_DATA cascade constraints;
drop TABLE MDMADM.D1_INSTALL_EVT cascade constraints;
drop TABLE MDMADM.D1_MANUFACTURER cascade constraints;
drop TABLE MDMADM.D1_MEASR_COMP cascade constraints;
drop TABLE MDMADM.D1_MEASR_COMP_TYPE cascade constraints;
drop TABLE MDMADM.D1_MKT cascade constraints;
drop TABLE MDMADM.D1_MODEL cascade constraints;
drop TABLE MDMADM.D1_MSRMT_CYC cascade constraints;
drop TABLE MDMADM.D1_MSRMT_CYC_RTE cascade constraints;
drop TABLE MDMADM.D1_MSRMT_CYC_SCHED cascade constraints;
drop TABLE MDMADM.D1_MSRMT_LOG cascade constraints;
drop TABLE MDMADM.D1_MSRMT_TMP cascade constraints;
drop TABLE MDMADM.D1_ON_OFF_HIST cascade constraints;
drop TABLE MDMADM.D1_PROC_MTHD cascade constraints;
drop TABLE MDMADM.D1_SP cascade constraints;
drop TABLE MDMADM.D1_SPR cascade constraints;
drop TABLE MDMADM.D1_SP_TYPE cascade constraints;
drop TABLE MDMADM.D1_SQI cascade constraints;
drop TABLE MDMADM.D1_SVC_TYPE cascade constraints;
drop TABLE MDMADM.D1_TOU cascade constraints;
drop TABLE MDMADM.D1_TOU_GRP cascade constraints;
drop TABLE MDMADM.D1_TOU_MAP cascade constraints;
drop TABLE MDMADM.D1_TOU_MAP_DATA_TMP cascade constraints;
drop TABLE MDMADM.D1_TOU_MAP_DATA_TMP2 cascade constraints;
drop TABLE MDMADM.D1_TOU_MAP_TMPLT cascade constraints;
drop TABLE MDMADM.D1_TOU_MAP_TYPE cascade constraints;
drop TABLE MDMADM.D1_USAGE cascade constraints;
drop TABLE MDMADM.D1_USAGE_PERIOD cascade constraints;
drop TABLE MDMADM.D1_USAGE_PERIOD_SQ cascade constraints;
drop TABLE MDMADM.D1_USAGE_SCALAR_DTL cascade constraints;
drop TABLE MDMADM.D1_USG_GRP cascade constraints;
drop TABLE MDMADM.D1_USG_RULE cascade constraints;
drop TABLE MDMADM.D1_USG_RULE_ELIG_CRIT cascade constraints;
drop TABLE MDMADM.D1_US_DYN_OPT cascade constraints;
drop TABLE MDMADM.D1_US_DYN_OPT_OVRRD cascade constraints;
drop TABLE MDMADM.D1_US_SP cascade constraints;
drop TABLE MDMADM.D1_US_TYPE cascade constraints;
drop TABLE MDMADM.D1_VEE_ELIG_CRIT cascade constraints;
drop TABLE MDMADM.D1_VEE_EXCP cascade constraints;
drop TABLE MDMADM.D1_VEE_GRP cascade constraints;
drop TABLE MDMADM.D1_VEE_RULE cascade constraints;
drop TABLE MDMADM.F1_BKT_CONFIG cascade constraints;
drop TABLE MDMADM.F1_BKT_CONFIG_VAL cascade constraints;
drop TABLE CCBADM.CM_DD_FILE cascade constraints;
drop TABLE CCBADM.CM_PROD_TIL cascade constraints;
drop TABLE CCBADM.CM_PROD_TIL_DETAILS cascade constraints;
drop TABLE MDMADM.D1_UOM cascade constraints;
drop TABLE MDMADM.D1_US cascade constraints;
drop TRIGGER CCBADM.CIFKVALID;
drop TRIGGER MDMADM.D1_TR_UPD_D1_SP;
drop TRIGGER MDMADM.D1_TR_INS_D1_SP;
drop TRIGGER MDMADM.CIFKVALID;
drop VIEW CCBADM.CI_LOOKUP;
drop VIEW CCBADM.CI_ROOT_OBJ_VW;
drop VIEW CCBADM.CI_SCTY_VAL_VW;
drop VIEW CCBADM.CI_USR_ACC_GRP_VW;
drop VIEW CCBADM.F1_ATTACHMENT_VW;
drop VIEW CCBADM.F1_LCBO_AUTO_ALG_VW;
drop VIEW CCBADM.F1_TD_FK_CHAR_ENTRY_VW;
drop VIEW CCBADM.CI_ACCTG_DAYS_VW;
drop VIEW CCBADM.CI_ACCT_CR_R_VW;
drop VIEW CCBADM.CI_ACCT_FT_HST_VW;
drop VIEW CCBADM.CI_ACDC_WOSA_VW;
drop VIEW CCBADM.CI_ADJTSAT_S_VW;
drop VIEW CCBADM.CI_ALG_ADHC_VW;
drop VIEW CCBADM.CI_ALG_ADJT_VW;
drop VIEW CCBADM.CI_ALG_BSBF_VW;
drop VIEW CCBADM.CI_ALG_BSBS_VW;
drop VIEW CCBADM.CI_ALG_CCAL_VW;
drop VIEW CCBADM.CI_ALG_CNSMP_VW;
drop VIEW CCBADM.CI_ALG_COCN_VW;
drop VIEW CCBADM.CI_ALG_COEV_VW;
drop VIEW CCBADM.CI_ALG_ERAC_VW;
drop VIEW CCBADM.CI_ALG_FACM_VW;
drop VIEW CCBADM.CI_ALG_GLAC_VW;
drop VIEW CCBADM.CI_ALG_GVFM_VW;
drop VIEW CCBADM.CI_ALG_IDFM_VW;
drop VIEW CCBADM.CI_ALG_LPCC_VW;
drop VIEW CCBADM.CI_ALG_LPCE_VW;
drop VIEW CCBADM.CI_ALG_ODSP_VW;
drop VIEW CCBADM.CI_ALG_PHFM_VW;
drop VIEW CCBADM.CI_ALG_PKCC_VW;
drop VIEW CCBADM.CI_ALG_PKEL_VW;
drop VIEW CCBADM.CI_ALG_PPBR_VW;
drop VIEW CCBADM.CI_ALG_PPOA_VW;
drop VIEW CCBADM.CI_ALG_PSEG_VW;
drop VIEW CCBADM.CI_ALG_PSPR_VW;
drop VIEW CCBADM.CI_ALG_PYDT_VW;
drop VIEW CCBADM.CI_ALG_SATBC_VW;
drop VIEW CCBADM.CI_ALG_SATFT_VW;
drop VIEW CCBADM.CI_ALG_SVCR_VW;
drop VIEW CCBADM.CI_ALG_SVEV_VW;
drop VIEW CCBADM.CI_ALG_XAR_VW;
drop VIEW CCBADM.CI_BAL_CTL_MEM_VW;
drop VIEW CCBADM.CI_BCHG_READ_VW;
drop VIEW CCBADM.CI_BCHG_UP_READ_VW;
drop VIEW CCBADM.CI_BSEG_READ_VW;
drop VIEW CCBADM.CI_CASE_ST_ALG_VW;
drop VIEW CCBADM.CI_CA_ACCT_HIS_VW;
drop VIEW CCBADM.CI_CC_ACCT_HST_VW;
drop VIEW CCBADM.CI_CEVTD_ACCHST_VW;
drop VIEW CCBADM.CI_CEVT_ACCHST_VW;
drop VIEW CCBADM.CI_CE_ACCT_HST_VW;
drop VIEW CCBADM.CI_CFG_SPMR2_VW;
drop VIEW CCBADM.CI_CFG_SPMR_VW;
drop VIEW CCBADM.CI_CHTY_ACC_VW;
drop VIEW CCBADM.CI_CHTY_ADJT_VW;
drop VIEW CCBADM.CI_CHTY_BCTL_VW;
drop VIEW CCBADM.CI_CHTY_BSCL_VW;
drop VIEW CCBADM.CI_CHTY_DIV_VW;
drop VIEW CCBADM.CI_CHTY_ITMTY_VW;
drop VIEW CCBADM.CI_CHTY_ITM_VW;
drop VIEW CCBADM.CI_CHTY_MTRTY_VW;
drop VIEW CCBADM.CI_CHTY_MTR_VW;
drop VIEW CCBADM.CI_CHTY_PER_VW;
drop VIEW CCBADM.CI_CHTY_PREM_VW;
drop VIEW CCBADM.CI_CHTY_SATY_VW;
drop VIEW CCBADM.CI_CHTY_SA_VW;
drop VIEW CCBADM.CI_CHTY_SCMT_VW;
drop VIEW CCBADM.CI_CHTY_SPTY_VW;
drop VIEW CCBADM.CI_CHTY_SP_VW;
drop VIEW CCBADM.CI_CO_ACCT_HST_VW;
drop VIEW CCBADM.CI_CPROC_ACCHST_VW;
drop VIEW CCBADM.CI_CP_ACCT_HST_VW;
drop VIEW CCBADM.CI_CR_ACCT_HST_VW;
drop VIEW CCBADM.CI_CURRENCY_VW;
drop VIEW CCBADM.CI_CURR_CUST_VW;
drop VIEW CCBADM.CI_DEG_MONTH_VW;
drop VIEW CCBADM.CI_DVTY_CHTY_VW;
drop VIEW CCBADM.CI_FA_ACCT_HST_VW;
drop VIEW CCBADM.CI_FT_GL_XTR_VW;
drop VIEW CCBADM.CI_FT_PROC_VW;
drop VIEW CCBADM.CI_INSTALLATION;
drop VIEW CCBADM.CI_ITEEVI_SP_VW;
drop VIEW CCBADM.CI_ITEM_CHTY_VW;
drop VIEW CCBADM.CI_ITEM_SP_E_VW;
drop VIEW CCBADM.CI_MR_RTEGEN_VW;
drop VIEW CCBADM.CI_MR_STGUP2_VW;
drop VIEW CCBADM.CI_MR_STG_UP_VW;
drop VIEW CCBADM.CI_MR_ST_EXC_VW;
drop VIEW CCBADM.CI_MR_VW;
drop VIEW CCBADM.CI_MTR_CHTY_VW;
drop VIEW CCBADM.CI_MTR_CNFG2_VW;
drop VIEW CCBADM.CI_MTR_CNFG_VW;
drop VIEW CCBADM.CI_NT_UP_EXC_VW;
drop VIEW CCBADM.CI_ODEVTD_ACCHST_VW;
drop VIEW CCBADM.CI_ODEVT_ACCHST_VW;
drop VIEW CCBADM.CI_ODPRC_ACCHST_VW;
drop VIEW CCBADM.CI_OMS_DEVICE_VW;
drop VIEW CCBADM.CI_OMS_FEEDER_VW;
drop VIEW CCBADM.CI_OMS_PHONE_VW;
drop VIEW CCBADM.CI_OMS_PRIC_VW;
drop VIEW CCBADM.CI_OMS_PRIK_VW;
drop VIEW CCBADM.CI_OMS_PRIM_VW;
drop VIEW CCBADM.CI_PAY_TND_VW;
drop VIEW CCBADM.CI_PAY_VW;
drop VIEW CCBADM.CI_PA_ACCT_HST_VW;
drop VIEW CCBADM.CI_PER_PRIM_VW;
drop VIEW CCBADM.CI_PP_ACCT_HST_VW;
drop VIEW CCBADM.CI_RC_ACCT_HIS_VW;
drop VIEW CCBADM.CI_REGRD_SEL_VW;
drop VIEW CCBADM.CI_RV_BF_RDR_VW;
drop VIEW CCBADM.CI_RV_BF_TXE_VW;
drop VIEW CCBADM.CI_RV_BF_VAL_VW;
drop VIEW CCBADM.CI_SA_IREG_VW;
drop VIEW CCBADM.CI_SA_RDR_VW;
drop VIEW CCBADM.CI_SA_SP_DT_VW;
drop VIEW CCBADM.CI_SA_TXE_VW;
drop VIEW CCBADM.CI_SA_VAL_VW;
drop VIEW CCBADM.CI_SED_ACCT_HST_VW;
drop VIEW CCBADM.CI_SE_ACCT_HST_VW;
drop VIEW CCBADM.CI_SP_CHTY_VW;
drop VIEW CCBADM.CI_SP_IT_EV_VW;
drop VIEW CCBADM.CI_SP_MTR_EV_VW;
drop VIEW CCBADM.CI_SV_ACCT_HST_VW;
drop VIEW CCBADM.CI_WE_ACCT_HST_VW;
drop VIEW CCBADM.CI_WO_ACCT_HST_VW;
drop VIEW MDMADM.CI_LOOKUP;
drop VIEW MDMADM.CI_ROOT_OBJ_VW;
drop VIEW MDMADM.CI_SCTY_VAL_VW;
drop VIEW MDMADM.CI_USR_ACC_GRP_VW;
drop VIEW MDMADM.F1_ATTACHMENT_VW;
drop VIEW MDMADM.F1_LCBO_AUTO_ALG_VW;
drop VIEW MDMADM.F1_TD_FK_CHAR_ENTRY_VW;
drop VIEW MDMADM.D1_CONTACT_VW;
drop VIEW MDMADM.D1_DEVICE_VW;
drop VIEW MDMADM.D1_INI_CONTACT_VW;
drop VIEW MDMADM.D1_INI_DVC_CFG_VW;
drop VIEW MDMADM.D1_INI_DVC_VW;
drop VIEW MDMADM.D1_INI_IE_VW;
drop VIEW MDMADM.D1_INI_MC_VW;
drop VIEW MDMADM.D1_INI_SP_VW;
drop VIEW MDMADM.D1_INI_US_VW;
drop VIEW MDMADM.D1_MEASR_COMP_VW;
drop VIEW MDMADM.D1_ON_CONTACT_VW;
drop VIEW MDMADM.D1_ON_DVC_CFG_VW;
drop VIEW MDMADM.D1_ON_DVC_VW;
drop VIEW MDMADM.D1_ON_IE_VW;
drop VIEW MDMADM.D1_ON_MC_VW;
drop VIEW MDMADM.D1_ON_SP_VW;
drop VIEW MDMADM.D1_ON_US_VW;
drop VIEW MDMADM.D1_SP_VW;
drop VIEW MDMADM.D1_US_VW;