SQL> @cntr.out SP2-0042: unknown command "SQL> /" - rest of line ignored. SP2-0734: unknown command beginning "'PROMPT---..." - rest of line ignored. ------ prompt MDMADM.CI_ACC_GRP CNT ---------------- 0 ------ prompt MDMADM.CI_ACC_GRP_DAR CNT ---------------- 0 ------ prompt MDMADM.CI_ACC_GRP_L CNT ---------------- 0 ------ prompt MDMADM.CI_ALG CNT ---------------- 997 ------ prompt MDMADM.CI_ALG_L CNT ---------------- 997 ------ prompt MDMADM.CI_ALG_PARM CNT ---------------- 1,586 ------ prompt MDMADM.CI_ALG_TYPE CNT ---------------- 886 ------ prompt MDMADM.CI_ALG_TYPE_L CNT ---------------- 886 ------ prompt MDMADM.CI_ALG_TYPE_PRM CNT ---------------- 1,103 ------ prompt MDMADM.CI_ALG_TYPE_PRM_L CNT ---------------- 1,103 ------ prompt MDMADM.CI_ALG_VER CNT ---------------- 894 ------ prompt MDMADM.CI_APP_SVC_ACC CNT ---------------- 1,887 ------ prompt MDMADM.CI_APP_SVC_SCTY CNT ---------------- 0 ------ prompt MDMADM.CI_ARC_ROOT_INST CNT ---------------- 0 ------ prompt MDMADM.CI_ARC_ROOT_INST_K CNT ---------------- 0 ------ prompt MDMADM.CI_ARC_ROOT_OBJ CNT ---------------- 0 ------ prompt MDMADM.CI_ARC_ROOT_OBJ_K CNT ---------------- 0 ------ prompt MDMADM.CI_ARC_ROOT_PK CNT ---------------- 0 ------ prompt MDMADM.CI_AUDIT CNT ---------------- 2,430 ------ prompt MDMADM.CI_AUDIT_K CNT ---------------- 2,430 ------ prompt MDMADM.CI_BATCH_CTRL CNT ---------------- 180 ------ prompt MDMADM.CI_BATCH_CTRL_ALG CNT ---------------- 0 ------ prompt MDMADM.CI_BATCH_CTRL_L CNT ---------------- 180 ------ prompt MDMADM.CI_BATCH_CTRL_P CNT ---------------- 918 ------ prompt MDMADM.CI_BATCH_CTRL_P_L CNT ---------------- 918 ------ prompt MDMADM.CI_BATCH_INST CNT ---------------- 3,839,925 ------ prompt MDMADM.CI_BATCH_JOB CNT ---------------- 1,069 ------ prompt MDMADM.CI_BATCH_JOB_K CNT ---------------- 1,069 ------ prompt MDMADM.CI_BATCH_JOB_PRM CNT ---------------- 6,353 ------ prompt MDMADM.CI_BATCH_RUN CNT ---------------- 334,140 ------ prompt MDMADM.CI_BATCH_THD CNT ---------------- 3,832,490 ------ prompt MDMADM.CI_CAL_HOL CNT ---------------- 62 ------ prompt MDMADM.CI_CAL_HOL_L CNT ---------------- 62 ------ prompt MDMADM.CI_CAL_WORK CNT ---------------- 1 ------ prompt MDMADM.CI_CAL_WORK_L CNT ---------------- 1 ------ prompt MDMADM.CI_CHAR_ENTITY CNT ---------------- 216 ------ prompt MDMADM.CI_CHAR_TYPE CNT ---------------- 122 ------ prompt MDMADM.CI_CHAR_TYPE_L CNT ---------------- 122 ------ prompt MDMADM.CI_CHAR_VAL CNT ---------------- 99 ------ prompt MDMADM.CI_CHAR_VAL_L CNT ---------------- 99 ------ prompt MDMADM.CI_CHTY_TDTY CNT ---------------- 0 ------ prompt MDMADM.CI_CNV_DUP_KEY CNT ---------------- 0 ------ prompt MDMADM.CI_CNV_KEY_TMP CNT ---------------- 0 ------ prompt MDMADM.CI_COUNTRY CNT ---------------- 3 ------ prompt MDMADM.CI_COUNTRY_L CNT ---------------- 3 ------ prompt MDMADM.CI_CURRENCY_CD CNT ---------------- 2 ------ prompt MDMADM.CI_CURRENCY_CD_L CNT ---------------- 2 ------ prompt MDMADM.CI_DAR CNT ---------------- 0 ------ prompt MDMADM.CI_DAR_L CNT ---------------- 0 ------ prompt MDMADM.CI_DAR_USR CNT ---------------- 0 ------ prompt MDMADM.CI_DATA_DIFF CNT ---------------- 0 ------ prompt MDMADM.CI_DATA_DIFF_PK CNT ---------------- 0 ------ prompt MDMADM.CI_DB_INSTR CNT ---------------- 0 ------ prompt MDMADM.CI_DB_INSTR_ALG CNT ---------------- 0 ------ prompt MDMADM.CI_DB_INSTR_L CNT ---------------- 0 ------ prompt MDMADM.CI_DB_INST_OVRD CNT ---------------- 0 ------ prompt MDMADM.CI_DB_PROC CNT ---------------- 0 ------ prompt MDMADM.CI_DB_PROC_L CNT ---------------- 0 ------ prompt MDMADM.CI_DISP_ICON CNT ---------------- 40 ------ prompt MDMADM.CI_DISP_ICON_L CNT ---------------- 40 ------ prompt MDMADM.CI_DISP_PROF CNT ---------------- 2 ------ prompt MDMADM.CI_DISP_PROF_L CNT ---------------- 2 ------ prompt MDMADM.CI_ENV_REF CNT ---------------- 0 ------ prompt MDMADM.CI_ENV_REF_L CNT ---------------- 0 ------ prompt MDMADM.CI_FK_REF CNT ---------------- 252 ------ prompt MDMADM.CI_FK_REF_L CNT ---------------- 252 ------ prompt MDMADM.CI_FUNC CNT ---------------- 0 ------ prompt MDMADM.CI_FUNC_FLD CNT ---------------- 0 ------ prompt MDMADM.CI_FUNC_FLD_L CNT ---------------- 0 ------ prompt MDMADM.CI_FUNC_L CNT ---------------- 0 ------ prompt MDMADM.CI_GEO_TYPE CNT ---------------- 0 ------ prompt MDMADM.CI_GEO_TYPE_L CNT ---------------- 0 ------ prompt MDMADM.CI_INSTALL_ALG CNT ---------------- 1 ------ prompt MDMADM.CI_INSTALL_MSG CNT ---------------- 0 ------ prompt MDMADM.CI_INSTALL_MSG_L CNT ---------------- 0 ------ prompt MDMADM.CI_INSTALL_PROD CNT ---------------- 5 ------ prompt MDMADM.CI_LANGUAGE CNT ---------------- 1 ------ prompt MDMADM.CI_LOOKUP_FIELD CNT ---------------- 620 ------ prompt MDMADM.CI_LOOKUP_VAL CNT ---------------- 2,598 ------ prompt MDMADM.CI_LOOKUP_VAL_L CNT ---------------- 2,598 ------ prompt MDMADM.CI_MD_ATT_TY CNT ---------------- 109 ------ prompt MDMADM.CI_MD_AT_DTL CNT ---------------- 108 ------ prompt MDMADM.CI_MD_AT_DTL_L CNT ---------------- 108 ------ prompt MDMADM.CI_MD_CONST CNT ---------------- 2,255 ------ prompt MDMADM.CI_MD_CONST_FLD CNT ---------------- 3,411 ------ prompt MDMADM.CI_MD_CTL CNT ---------------- 20 ------ prompt MDMADM.CI_MD_CTL_L CNT ---------------- 20 ------ prompt MDMADM.CI_MD_CTL_TMPL CNT ---------------- 225 ------ prompt MDMADM.CI_MD_ELTY CNT ---------------- 36 ------ prompt MDMADM.CI_MD_ELTY_AT CNT ---------------- 489 ------ prompt MDMADM.CI_MD_ELTY_L CNT ---------------- 36 ------ prompt MDMADM.CI_MD_FLD CNT ---------------- 7,828 ------ prompt MDMADM.CI_MD_FLD_L CNT ---------------- 7,809 ------ prompt MDMADM.CI_MD_LOOKUP_F CNT ---------------- 12 ------ prompt MDMADM.CI_MD_MENU CNT ---------------- 64 ------ prompt MDMADM.CI_MD_MENU_IMOD CNT ---------------- 202 ------ prompt MDMADM.CI_MD_MENU_ITEM CNT ---------------- 445 ------ prompt MDMADM.CI_MD_MENU_ITEM_L CNT ---------------- 445 ------ prompt MDMADM.CI_MD_MENU_L CNT ---------------- 64 ------ prompt MDMADM.CI_MD_MENU_LINE CNT ---------------- 311 ------ prompt MDMADM.CI_MD_MENU_LINE_L CNT ---------------- 311 ------ prompt MDMADM.CI_MD_MENU_MOD CNT ---------------- 0 ------ prompt MDMADM.CI_MD_MO CNT ---------------- 185 ------ prompt MDMADM.CI_MD_MO_ALG CNT ---------------- 118 ------ prompt MDMADM.CI_MD_MO_L CNT ---------------- 185 ------ prompt MDMADM.CI_MD_MO_OPT CNT ---------------- 964 ------ prompt MDMADM.CI_MD_MO_TBL CNT ---------------- 696 ------ prompt MDMADM.CI_MD_MO_WRK CNT ---------------- 0 ------ prompt MDMADM.CI_MD_MSG CNT ---------------- 51 ------ prompt MDMADM.CI_MD_MSG_L CNT ---------------- 51 ------ prompt MDMADM.CI_MD_NAV CNT ---------------- 1,337 ------ prompt MDMADM.CI_MD_PDF CNT ---------------- 18 ------ prompt MDMADM.CI_MD_PDF_VAL CNT ---------------- 58 ------ prompt MDMADM.CI_MD_PRG_COM CNT ---------------- 1,023 ------ prompt MDMADM.CI_MD_PRG_ELEM CNT ---------------- 5,661 ------ prompt MDMADM.CI_MD_PRG_EL_AT CNT ---------------- 2,965 ------ prompt MDMADM.CI_MD_PRG_LOC CNT ---------------- 148 ------ prompt MDMADM.CI_MD_PRG_MOD CNT ---------------- 1 ------ prompt MDMADM.CI_MD_PRG_SEC CNT ---------------- 1,247 ------ prompt MDMADM.CI_MD_PRG_SQL CNT ---------------- 0 ------ prompt MDMADM.CI_MD_PRG_TAB CNT ---------------- 352 ------ prompt MDMADM.CI_MD_PRG_VAR CNT ---------------- 2,654 ------ prompt MDMADM.CI_MD_RPT CNT ---------------- 0 ------ prompt MDMADM.CI_MD_RPT_L CNT ---------------- 0 ------ prompt MDMADM.CI_MD_RPT_LBL CNT ---------------- 0 ------ prompt MDMADM.CI_MD_RPT_PARM CNT ---------------- 0 ------ prompt MDMADM.CI_MD_RPT_PARM_L CNT ---------------- 0 ------ prompt MDMADM.CI_MD_SO CNT ---------------- 0 ------ prompt MDMADM.CI_MD_SOCG CNT ---------------- 0 ------ prompt MDMADM.CI_MD_SOCG_FLD CNT ---------------- 0 ------ prompt MDMADM.CI_MD_SOCG_FLDAT CNT ---------------- 0 ------ prompt MDMADM.CI_MD_SOCG_L CNT ---------------- 0 ------ prompt MDMADM.CI_MD_SOCG_SORT CNT ---------------- 0 ------ prompt MDMADM.CI_MD_SO_L CNT ---------------- 0 ------ prompt MDMADM.CI_MD_SO_RSFLD CNT ---------------- 0 ------ prompt MDMADM.CI_MD_SO_RSFLDAT CNT ---------------- 0 ------ prompt MDMADM.CI_MD_SRC_TYPE CNT ---------------- 8 ------ prompt MDMADM.CI_MD_SRC_TYPE_L CNT ---------------- 8 ------ prompt MDMADM.CI_MD_SVC CNT ---------------- 845 ------ prompt MDMADM.CI_MD_SVC_L CNT ---------------- 845 ------ prompt MDMADM.CI_MD_SVC_PRG CNT ---------------- 530 ------ prompt MDMADM.CI_MD_TAB_MOD CNT ---------------- 8 ------ prompt MDMADM.CI_MD_TBL CNT ---------------- 780 ------ prompt MDMADM.CI_MD_TBL_FLD CNT ---------------- 5,865 ------ prompt MDMADM.CI_MD_TBL_FLD_L CNT ---------------- 5,867 ------ prompt MDMADM.CI_MD_TBL_L CNT ---------------- 780 ------ prompt MDMADM.CI_MD_TMPL CNT ---------------- 61 ------ prompt MDMADM.CI_MD_TMPL_ELTY CNT ---------------- 409 ------ prompt MDMADM.CI_MD_TMPL_L CNT ---------------- 61 ------ prompt MDMADM.CI_MD_TMPL_VAR CNT ---------------- 2,486 ------ prompt MDMADM.CI_MD_TMPL_VAR_L CNT ---------------- 2,137 ------ prompt MDMADM.CI_MD_TOOLREP_XML CNT ---------------- 0 ------ prompt MDMADM.CI_MD_TOOL_REP CNT ---------------- 0 ------ prompt MDMADM.CI_MD_VAR CNT ---------------- 559 ------ prompt MDMADM.CI_MD_VAR_DTL CNT ---------------- 602 ------ prompt MDMADM.CI_MD_VAR_DTL_L CNT ---------------- 602 ------ prompt MDMADM.CI_MD_WRK_TBL CNT ---------------- 0 ------ prompt MDMADM.CI_MD_WRK_TBLFLD CNT ---------------- 0 ------ prompt MDMADM.CI_MD_WRK_TBL_L CNT ---------------- 0 ------ prompt MDMADM.CI_MPL_EXC CNT ---------------- 0 ------ prompt MDMADM.CI_MSG CNT ---------------- 3,499 ------ prompt MDMADM.CI_MSG_CATEGORY CNT ---------------- 30 ------ prompt MDMADM.CI_MSG_CATEGORY_L CNT ---------------- 30 ------ prompt MDMADM.CI_MSG_L CNT ---------------- 3,498 ------ prompt MDMADM.CI_MSG_LOG CNT ---------------- 30,258,921 ------ prompt MDMADM.CI_MSG_LOGPARM CNT ---------------- 51,438,463 ------ prompt MDMADM.CI_MSG_LOG_PK CNT ---------------- 0 ------ prompt MDMADM.CI_NAV_OPT CNT ---------------- 684 ------ prompt MDMADM.CI_NAV_OPT_CTXT CNT ---------------- 388 ------ prompt MDMADM.CI_NAV_OPT_L CNT ---------------- 684 ------ prompt MDMADM.CI_NAV_OPT_USG CNT ---------------- 1,128 ------ prompt MDMADM.CI_NT_DNTY_CTXT CNT ---------------- 0 ------ prompt MDMADM.CI_NT_DWN CNT ---------------- 0 ------ prompt MDMADM.CI_NT_DWN_CHAR CNT ---------------- 0 ------ prompt MDMADM.CI_NT_DWN_CTXT CNT ---------------- 0 ------ prompt MDMADM.CI_NT_DWN_EXC CNT ---------------- 0 ------ prompt MDMADM.CI_NT_DWN_EXP CNT ---------------- 0 ------ prompt MDMADM.CI_NT_DWN_FORM CNT ---------------- 0 ------ prompt MDMADM.CI_NT_DWN_FORM_L CNT ---------------- 0 ------ prompt MDMADM.CI_NT_DWN_K CNT ---------------- 0 ------ prompt MDMADM.CI_NT_DWN_PROF CNT ---------------- 0 ------ prompt MDMADM.CI_NT_DWN_PROF_L CNT ---------------- 0 ------ prompt MDMADM.CI_NT_DWN_TYPE CNT ---------------- 0 ------ prompt MDMADM.CI_NT_DWN_TYPE_L CNT ---------------- 0 ------ prompt MDMADM.CI_NT_UP CNT ---------------- 0 ------ prompt MDMADM.CI_NT_UP_CHAR CNT ---------------- 0 ------ prompt MDMADM.CI_NT_UP_CTXT CNT ---------------- 0 ------ prompt MDMADM.CI_NT_UP_EXCP CNT ---------------- 0 ------ prompt MDMADM.CI_NT_UP_XTYPE CNT ---------------- 0 ------ prompt MDMADM.CI_NT_UP_XTYPE_L CNT ---------------- 0 ------ prompt MDMADM.CI_NT_XID CNT ---------------- 5 ------ prompt MDMADM.CI_NT_XID_L CNT ---------------- 5 ------ prompt MDMADM.CI_PHONE_TYPE CNT ---------------- 2 ------ prompt MDMADM.CI_PHONE_TYPE_L CNT ---------------- 2 ------ prompt MDMADM.CI_PORTAL CNT ---------------- 177 ------ prompt MDMADM.CI_PORTAL_L CNT ---------------- 177 ------ prompt MDMADM.CI_PORTAL_ZONE CNT ---------------- 370 ------ prompt MDMADM.CI_ROLE CNT ---------------- 7 ------ prompt MDMADM.CI_ROLE_L CNT ---------------- 7 ------ prompt MDMADM.CI_ROLE_USER CNT ---------------- 2,686 ------ prompt MDMADM.CI_ROOT_DIFF CNT ---------------- 0 ------ prompt MDMADM.CI_ROOT_INSTR CNT ---------------- 0 ------ prompt MDMADM.CI_ROOT_INSTR_K CNT ---------------- 0 ------ prompt MDMADM.CI_ROOT_OBJ CNT ---------------- 0 ------ prompt MDMADM.CI_ROOT_OBJ_EXC CNT ---------------- 0 ------ prompt MDMADM.CI_ROOT_OBJ_EXP CNT ---------------- 0 ------ prompt MDMADM.CI_ROOT_OBJ_K CNT ---------------- 0 ------ prompt MDMADM.CI_ROOT_OBJ_PK CNT ---------------- 0 ------ prompt MDMADM.CI_RPT_OPTION CNT ---------------- 0 ------ prompt MDMADM.CI_SCR CNT ---------------- 1,394 ------ prompt MDMADM.CI_SCR_CRT CNT ---------------- 0 ------ prompt MDMADM.CI_SCR_CRT_GRP CNT ---------------- 0 ------ prompt MDMADM.CI_SCR_CRT_GRP_L CNT ---------------- 0 ------ prompt MDMADM.CI_SCR_DA CNT ---------------- 5,277 ------ prompt MDMADM.CI_SCR_FLD_MAP CNT ---------------- 0 ------ prompt MDMADM.CI_SCR_L CNT ---------------- 1,392 ------ prompt MDMADM.CI_SCR_PRMPT CNT ---------------- 72 ------ prompt MDMADM.CI_SCR_PRMPT_L CNT ---------------- 72 ------ prompt MDMADM.CI_SCR_STEP CNT ---------------- 4,588 ------ prompt MDMADM.CI_SCR_STEP_L CNT ---------------- 4,588 ------ prompt MDMADM.CI_SC_AUTH_LVL CNT ---------------- 0 ------ prompt MDMADM.CI_SC_AUTH_LVL_L CNT ---------------- 0 ------ prompt MDMADM.CI_SC_TYPE CNT ---------------- 0 ------ prompt MDMADM.CI_SC_TYPE_L CNT ---------------- 0 ------ prompt MDMADM.CI_SEAS_SHIFT CNT ---------------- 0 ------ prompt MDMADM.CI_SEAS_TM_SHIFT CNT ---------------- 0 ------ prompt MDMADM.CI_SEAS_TM_SHIFT_L CNT ---------------- 0 ------ prompt MDMADM.CI_SEQ CNT ---------------- 2 ------ prompt MDMADM.CI_STATE CNT ---------------- 58 ------ prompt MDMADM.CI_STATE_L CNT ---------------- 58 ------ prompt MDMADM.CI_SYSDATA_LOG CNT ---------------- 0 ------ prompt MDMADM.CI_TD_DRLKEY select count(*) as "CNT" from MDMADM.CI_TD_DRLKEY * ERROR at line 1: ORA-01013: user requested cancel of current operation SQL> SQL> SQL> SQL> SQL> connect ccbadm/CCBADM Connected. SQL> SQL> SQL> SQL> SQL> SQL> desc user_tables Name Null? Type ----------------------------------------- -------- ---------------------------- TABLE_NAME NOT NULL VARCHAR2(30) TABLESPACE_NAME VARCHAR2(30) CLUSTER_NAME VARCHAR2(30) IOT_NAME VARCHAR2(30) STATUS VARCHAR2(8) PCT_FREE NUMBER PCT_USED NUMBER INI_TRANS NUMBER MAX_TRANS NUMBER INITIAL_EXTENT NUMBER NEXT_EXTENT NUMBER MIN_EXTENTS NUMBER MAX_EXTENTS NUMBER PCT_INCREASE NUMBER FREELISTS NUMBER FREELIST_GROUPS NUMBER LOGGING VARCHAR2(3) BACKED_UP VARCHAR2(1) NUM_ROWS NUMBER BLOCKS NUMBER EMPTY_BLOCKS NUMBER AVG_SPACE NUMBER CHAIN_CNT NUMBER AVG_ROW_LEN NUMBER AVG_SPACE_FREELIST_BLOCKS NUMBER NUM_FREELIST_BLOCKS NUMBER DEGREE VARCHAR2(40) INSTANCES VARCHAR2(40) CACHE VARCHAR2(20) TABLE_LOCK VARCHAR2(8) SAMPLE_SIZE NUMBER LAST_ANALYZED DATE PARTITIONED VARCHAR2(3) IOT_TYPE VARCHAR2(12) TEMPORARY VARCHAR2(1) SECONDARY VARCHAR2(1) NESTED VARCHAR2(3) BUFFER_POOL VARCHAR2(7) FLASH_CACHE VARCHAR2(7) CELL_FLASH_CACHE VARCHAR2(7) ROW_MOVEMENT VARCHAR2(8) GLOBAL_STATS VARCHAR2(3) USER_STATS VARCHAR2(3) DURATION VARCHAR2(15) SKIP_CORRUPT VARCHAR2(8) MONITORING VARCHAR2(3) CLUSTER_OWNER VARCHAR2(30) DEPENDENCIES VARCHAR2(8) COMPRESSION VARCHAR2(8) COMPRESS_FOR VARCHAR2(12) DROPPED VARCHAR2(3) READ_ONLY VARCHAR2(3) SEGMENT_CREATED VARCHAR2(3) RESULT_CACHE VARCHAR2(7) SQL> select TABLE_NAME,NUM_ROWS from user_tables order by TABLE_NAME; TABLE_NAME NUM_ROWS ------------------------------ ---------- C0_INSTALLATION 1 C1_CALC_GRP 687 C1_CALC_GRP_CHAR 0 C1_CALC_GRP_L 687 C1_CALC_RULE 1780 C1_CALC_RULE_CHAR 1144 C1_CALC_RULE_CRT 20 C1_CALC_RULE_CRT_CHAR 0 C1_CALC_RULE_CRT_L 20 C1_CALC_RULE_L 1732 C1_CALC_RULE_MBR_CAT 1381 C1_CALC_RULE_TRGT_CAT 76 C1_CL_CAT_TYPE 3 C1_CL_CAT_TYPE_CHAR 0 C1_CL_CAT_TYPE_L 3 C1_CL_CAT_VAL 3 C1_CL_CAT_VAL_L 3 C1_COMM_RTE_TYPE 0 C1_COMM_RTE_TYPE_CHAR 0 C1_COMM_RTE_TYPE_DVTYP 0 C1_COMM_RTE_TYPE_L 0 C1_INITIATIVE 0 C1_INITIATIVE_CHAR 0 C1_INITIATIVE_CRITERIA 0 C1_INITIATIVE_CRITERIA_CHAR 0 C1_INITIATIVE_CRITERIA_L 0 C1_INITIATIVE_L 0 C1_INITIATIVE_LEAD_DEFN 0 C1_INITIATIVE_LOG 0 C1_INITIATIVE_LOG_PARM 0 C1_INITIATIVE_REL_OBJ 0 C1_INTV_DATA_GTT C1_ISS_CTR 0 C1_ISS_CTR_CHAR 0 C1_ISS_CTR_DTL 0 C1_ISS_CTR_L 0 C1_ISS_CTR_LOG 0 C1_ISS_CTR_LOG_PARM 0 C1_LEAD 0 C1_LEAD_CHAR 0 C1_LEAD_EVT 0 C1_LEAD_EVT_CHAR 0 C1_LEAD_EVT_K 0 C1_LEAD_EVT_LOG 0 C1_LEAD_EVT_LOG_PARM 0 C1_LEAD_EVT_STEP 0 C1_LEAD_EVT_STEP_K 0 C1_LEAD_EVT_TYPE 0 C1_LEAD_EVT_TYPE_CHAR 0 C1_LEAD_EVT_TYPE_L 0 C1_LEAD_K 0 C1_LEAD_LOG 0 C1_LEAD_LOG_PARM 0 C1_LEAD_REL_OBJ 0 C1_LETY_STEP_TYPE 0 C1_LETY_STEP_TYPE_L 0 C1_NTF_PREF 0 C1_NTF_PREF_CHAR 0 C1_NTF_PREF_ID 0 C1_NTF_PREF_K 0 C1_NTF_PREF_LOG 0 C1_NTF_PREF_LOG_PARM 0 C1_NTF_TYPE 0 C1_NTF_TYPE_ALG 0 C1_NTF_TYPE_CHAR 0 C1_NTF_TYPE_COMM_RTE_TYPE 0 C1_NTF_TYPE_DVTYP 0 C1_NTF_TYPE_L 0 C1_OFFCYC_BGEN 1474758 C1_OFFCYC_BGEN_ADJ 0 C1_OFFCYC_BGEN_BCHG 0 C1_OFFCYC_BGEN_CHAR 353739 C1_OFFCYC_BGEN_K 1474758 C1_OFFCYC_BGEN_LOG 5901354 C1_OFFCYC_BGEN_LOG_PARM 6150705 C1_OFFCYC_BGEN_SA 1474758 C1_PER_CONTDET 0 C1_PER_CONT_DET_K 0 C1_PREM_ACTIVITY_GTT C1_RC_CALC_GTT C1_RC_CALC_LN_GTT C1_RC_CHAR_GTT C1_RC_READ_GTT C1_RC_SQ_GTT C1_RC_TRACE_GTT C1_REPRESENTATIVE 0 C1_REPRESENTATIVE_CHAR 0 C1_REPRESENTATIVE_L 0 C1_REPRESENTATIVE_LOG 0 C1_REPRESENTATIVE_LOG_PARM 0 C1_REP_GRP_MEM 0 C1_RS_POST_PROC 464 C1_RS_POST_PROC_L 464 C1_RS_PRE_PROC 464 C1_RS_PRE_PROC_L 464 C1_RS_RV2 539 C1_RS_RV2_L 539 C1_TOU_MAP 0 C1_TOU_MAP_CHAR 0 C1_TOU_MAP_DATA 0 C1_TOU_MAP_DATA_CHAR 0 C1_TOU_MAP_K 0 C1_TOU_MAP_L 0 C1_TOU_MAP_LOG 0 C1_TOU_MAP_LOG_PARM 0 C1_TOU_MAP_TMPLT 0 C1_TOU_MAP_TMPLT_CHAR 0 C1_TOU_MAP_TMPLT_L 0 C1_TOU_MAP_TYPE 0 C1_TOU_MAP_TYPE_CHAR 0 C1_TOU_MAP_TYPE_L 0 C1_TOU_MAP_TYPE_TMPLT 0 C1_USAGE 18760111 C1_USAGE_CHAR 0 C1_USAGE_K 18910273 C1_USAGE_LOG 126851716 C1_USAGE_LOG_PARM 101139953 C1_USER_TNDR_SRCE 1 CCBADM_STATS_1 49929 CI_ACCT 547069 CI_ACCT_ALERT 221173 CI_ACCT_ALERT_190615 25923 CI_ACCT_APAY 494335 CI_ACCT_APAY_K 494335 CI_ACCT_CHAR 6821898 CI_ACCT_K 546310 CI_ACCT_MGMT_GR 0 CI_ACCT_MGMT_GR_L 0 CI_ACCT_MGRP_RL 0 CI_ACCT_MSG 1 CI_ACCT_MSG_PRM 0 CI_ACCT_PER 631592 CI_ACCT_REL_TYP 13 CI_ACCT_REL_TYP_L 13 CI_ACCT_STG 0 CI_ACC_GRP 1 CI_ACC_GRP_DAR 1 CI_ACC_GRP_L 1 CI_ADJ 21482258 CI_ADJT_ADJTPRF 91 CI_ADJ_APREQ 154535 CI_ADJ_APREQ_K 154535 CI_ADJ_CALC_LN 242026 CI_ADJ_CAN_RSN 4 CI_ADJ_CAN_RSN_L 4 CI_ADJ_CHAR 622476 CI_ADJ_CL_CHAR 0 CI_ADJ_K 20758780 CI_ADJ_STG_CTL 50 CI_ADJ_STG_CTL_CHAR 150 CI_ADJ_STG_CTL_MSGP 0 CI_ADJ_STG_UP 330072 CI_ADJ_STG_UP_CHAR 660144 CI_ADJ_STG_UP_MSGP 18747 CI_ADJ_TYPE 92 CI_ADJ_TYPE_L 92 CI_ADJ_TYP_PROF 7 CI_ADJ_TYP_PROF_L 7 CI_ADJ_TY_ALG 157 CI_ADJ_TY_CHAR 1 CI_ADM_RVW_SCH 134131 CI_ALERT_TYPE 20 CI_ALERT_TYPE_L 20 CI_ALG 1323 CI_ALG_L 1323 CI_ALG_PARM 3737 CI_ALG_TYPE 1262 CI_ALG_TYPE_L 1262 CI_ALG_TYPE_PRM 3324 CI_ALG_TYPE_PRM_L 3324 CI_ALG_VER 1314 CI_AM_ACTIVITY_TYPE 0 CI_AM_ACTIVITY_TYPE_L 0 CI_AM_REQ 0 CI_AM_REQ_K 0 CI_AM_REQ_LOG 0 CI_AM_REQ_LOG_PARM 0 CI_APAY_CLR_STG 7106348 CI_APAY_CLR_STG_K 6615481 CI_APAY_RT_TYPE 2 CI_APAY_RT_TYPE_L 2 CI_APAY_SRC 9436 CI_APAY_SRC_L 9436 CI_APPR_PROF 4 CI_APPR_PROF_L 4 CI_APPR_REQ 172262 CI_APPR_REQ_CHAR 0 CI_APPR_REQ_K 172252 CI_APPR_REQ_LOG 1161469 CI_APPR_REQ_LOG_PARM 495427 CI_APP_SVC_ACC 2493 CI_APP_SVC_SCTY 9 CI_APREQ_TYPE 5 CI_APREQ_TYPE_L 5 CI_ARC_ROOT_INST 0 CI_ARC_ROOT_INST_K 0 CI_ARC_ROOT_OBJ 0 CI_ARC_ROOT_OBJ_K 0 CI_ARC_ROOT_PK 0 CI_AUDIT 109443195 CI_AUDIT_K 109443195 CI_BAL_CTL_GRP 1 CI_BAL_CTL_MEM 31 CI_BAL_CTL_TMP 31 CI_BANK 1 CI_BANK_ACCOUNT 5 CI_BANK_ACCOUNT_L 5 CI_BANK_L 1 CI_BATCH_CTRL 773 CI_BATCH_CTRL_ALG 28 CI_BATCH_CTRL_L 806 CI_BATCH_CTRL_P 2167 CI_BATCH_CTRL_P_L 2167 CI_BATCH_INST 4130429 CI_BATCH_JOB 3952 CI_BATCH_JOB_K 3666 CI_BATCH_JOB_PRM 17871 CI_BATCH_RUN 261990 CI_BATCH_THD 4127816 CI_BCHG_LINE_UP 0 CI_BCHG_READ 1 CI_BCHG_SQ 1 CI_BCHG_UP 0 CI_BCHG_UP_EXCP 0 CI_BCHG_UP_OVRD 0 CI_BCHG_UP_READ 0 CI_BCHG_UP_SQ 0 CI_BCHG_UP_XTYP 0 CI_BCHG_UP_XTYP_L 0 CI_BF 560 CI_BFCH_TOUGRP 0 CI_BF_CHAR 7058 CI_BF_CHAR_DST 0 CI_BF_L 560 CI_BF_VAL 12559 CI_BILL 4137500 CI_BILL_CAN_RSN 8 CI_BILL_CAN_RSN_L 8 CI_BILL_CHAR 0 CI_BILL_CHG 1 CI_BILL_CHG_K 1 CI_BILL_CYC 464 CI_BILL_CYC_L 464 CI_BILL_CYC_SCH 2084 CI_BILL_EXCP 13470 CI_BILL_K 4099205 CI_BILL_MSG 3 CI_BILL_MSGS 290 CI_BILL_MSG_L 3 CI_BILL_MSG_PRM 273 CI_BILL_PERIOD 0 CI_BILL_PERIOD_L 0 CI_BILL_PER_SCH 0 CI_BILL_ROUTING 4023879 CI_BILL_RT_TYPE 6 CI_BILL_RT_TYPE_L 6 CI_BILL_RVW_SCH 0 CI_BILL_SA 12630783 CI_BILL_SCNR 4 CI_BILL_SCNR_K 4 CI_BILL_SCNR_SQ 0 CI_BILL_SEG_TYP 7 CI_BILL_SEG_TYP_L 7 CI_BPRT_GRP 0 CI_BPRT_GRP_K 0 CI_BPRT_SGRP_SA 0 CI_BPRT_SUBGRP 0 CI_BSEG 8278001 CI_BSEG_CALC 13601659 CI_BSEG_CALC_LN 29256233 CI_BSEG_CL_CHAR 18741402 CI_BSEG_EXCP 119148 CI_BSEG_ITEM 0 CI_BSEG_K 8203383 CI_BSEG_MSG 3729197 CI_BSEG_READ 38860920 CI_BSEG_SQ 19869173 CI_BUD_PLAN 0 CI_BUD_PLAN_L 0 CI_BUD_RVW 0 CI_B_CHG_LINE 1 CI_B_CHG_TMPLT 0 CI_B_CHG_TMPLT_L 0 CI_B_LN_CHAR 0 CI_B_LN_UP_CHAR 0 CI_B_TMPLT_LINE 0 CI_B_TMPLT_LINE_L 0 CI_B_TMPLT_SQ 0 CI_B_TM_LN_CHA 0 CI_CAL_GL 1 CI_CAL_GL_L 1 CI_CAL_HOL 49 CI_CAL_HOL_L 49 CI_CAL_PERIOD 97 CI_CAL_PERIOD_L 97 CI_CAL_WORK 1 CI_CAL_WORK_L 1 CI_CAMPAIGN 0 CI_CAMPAIGN_L 0 CI_CAMP_ALG 0 CI_CAMP_FLD_TYPE 0 CI_CAMP_FLD_TYPE_L 0 CI_CASE 564861 CI_CASE_CHAR 4598271 CI_CASE_K 555551 CI_CASE_LOG 6175160 CI_CASE_LOG_PARM 11785539 CI_CASE_STATUS 149 CI_CASE_STATUS_L 149 CI_CASE_ST_ALG 153 CI_CASE_ST_CHTY 302 CI_CASE_TR_RULE 231 CI_CASE_TR_RULE_L 231 CI_CASE_TYPE 13 CI_CASE_TYPE_ALG 1 CI_CASE_TYPE_L 13 CI_CC 7183901 CI_CCL_CTL_ALG 19 CI_CC_CHAR 8086184 CI_CC_CL 18 CI_CC_CL_L 18 CI_CC_K 7183901 CI_CC_LOG 1313346 CI_CC_LOG_K 1313346 CI_CC_TYPE 167 CI_CC_TYPE_L 167 CI_CEVT_CAN_RSN 0 CI_CEVT_CAN_RSN_L 0 CI_CHAR_DFLT 0 CI_CHAR_DFLT_SV 0 CI_CHAR_ENTITY 563 CI_CHAR_TYPE 402 CI_CHAR_TYPE_L 402 CI_CHAR_VAL 655 CI_CHAR_VAL_L 655 CI_CHG_LOG 0 CI_CHTY_ADJTY 37 CI_CHTY_CASETY 127 CI_CHTY_CCTY 204 CI_CHTY_COPTY 0 CI_CHTY_COP_ETY 0 CI_CHTY_DV_TTYP 0 CI_CHTY_FATY 0 CI_CHTY_ITTY 0 CI_CHTY_MTTY 10 CI_CHTY_SCMTY 1 CI_CHTY_SPTY 37 CI_CHTY_TDTY 85 CI_CHTY_TOSTY 0 CI_CHTY_UATY 0 CI_CIS_DIVISION 1 CI_CIS_DIVISION_L 1 CI_CIS_DIV_CHAR 0 CI_CNV_DUP_KEY 0 CI_CNV_KEY_TMP 0 CI_COLL_AGY 13 CI_COLL_AGY_HIS 47198 CI_COLL_AGY_L 13 CI_COLL_AGY_REF 30112 CI_COLL_AGY_REF_K 30112 CI_COLL_CL 4 CI_COLL_CL_CNTL 2 CI_COLL_CL_CNTL_L 2 CI_COLL_CL_L 4 CI_COLL_CRIT 2 CI_COLL_CRIT_CT 2 CI_COLL_EVT 3802913 CI_COLL_EVT_CC 741235 CI_COLL_EVT_TYP 14 CI_COLL_EVT_TYP_L 14 CI_COLL_PROC 449414 CI_COLL_PROC_K 449414 CI_COLL_PROC_SA 521259 CI_COLL_PROC_TM 2 CI_COLL_PROC_TM_L 2 CI_COLL_RESP 18 CI_COL_REF 0 CI_COL_REF_ALG 0 CI_COL_REF_L 0 CI_CONSV_PROG 0 CI_CONSV_PROG_CHAR 0 CI_CONSV_PROG_L 0 CI_CONT_QTY_TMP 0 CI_CONT_QTY_TYP 0 CI_CONT_QTY_TYP_L 0 CI_COP 0 CI_COP_CHAR 0 CI_COP_EVT 0 CI_COP_EVT_CHAR 0 CI_COP_EVT_EXC 0 CI_COP_EVT_EXP 0 CI_COP_EVT_K 0 CI_COP_EVT_TYPE 0 CI_COP_EVT_TYPE_L 0 CI_COP_K 0 CI_COP_L 0 CI_COP_TYPE 0 CI_COP_TYPE_ALG 0 CI_COP_TYPE_L 0 CI_COUNTRY 1 CI_COUNTRY_L 1 CI_CR_RAT_HIST 129 CI_CR_RAT_HIST_K 129 CI_CR_UNIT 1 CI_CR_UNIT_L 1 CI_CURRENCY_CD 1 CI_CURRENCY_CD_L 1 CI_CUST_CL 5 CI_CUST_CL_CTRL 2 CI_CUST_CL_L 5 CI_CUST_CL_MSG 0 CI_CUT_EVT 0 CI_CUT_EVT_DEP 0 CI_CUT_EVT_TYPE 0 CI_CUT_EVT_TYPE_L 0 CI_CUT_EVT_TYP_ALG 0 CI_CUT_PROC 0 CI_CUT_PROC_K 0 CI_CUT_PROC_TMP 0 CI_CUT_PROC_TMP_L 0 CI_CUT_PROC_TM_ALG 0 CI_CUT_RESP 0 CI_CUT_RESP_DEP 0 CI_CVAL_TMPL 0 CI_CVAL_TOU_TMP 0 CI_DAR 1 CI_DAR_L 1 CI_DAR_USR 2062 CI_DATA_DIFF 0 CI_DATA_DIFF_PK 0 CI_DB_INSTR 4 CI_DB_INSTR_ALG 1 CI_DB_INSTR_L 4 CI_DB_INST_OVRD 1 CI_DB_PROC 1 CI_DB_PROC_L 1 CI_DCL 0 CI_DCL_K 0 CI_DC_ALG 5 CI_DEBT_CL 5 CI_DEBT_CL_L 5 CI_DEG_DAY 0 CI_DEP_CL 0 CI_DEP_CL_L 0 CI_DEP_CTL 2812 CI_DEP_CTL_CHAR 0 CI_DEP_CTL_K 2812 CI_DEP_CTL_ST 2130 CI_DEP_CTL_ST_091215 1 CI_DEP_CTL_ST_271015 462 CI_DEP_CTL_ST_BACKUP 391 CI_DEP_RVW 0 CI_DG_APP_SCHED 0 CI_DG_APP_SCHED_K 0 CI_DISCON_LOC 1 CI_DISCON_LOC_L 1 CI_DISP_GRP 0 CI_DISP_GRP_ALG 0 CI_DISP_GRP_L 0 CI_DISP_GRP_REP 0 CI_DISP_ICON 61 CI_DISP_ICON_L 61 CI_DISP_PROF 2 CI_DISP_PROF_L 2 CI_DIV_TD_ROLE 0 CI_DST_CD_CHAR 5 CI_DST_CODE 27 CI_DST_CODE_EFF 27 CI_DST_CODE_L 27 CI_DST_RULE 0 CI_DST_RULE_ALG 0 CI_DST_RULE_L 0 CI_DV_TEST 0 CI_DV_TEST_CHAR 0 CI_DV_TEST_COMP 0 CI_DV_TEST_EXCP 0 CI_DV_TEST_K 0 CI_DV_TEST_RES 0 CI_DV_TEST_SEL 0 CI_DV_TEST_SEL_K 0 CI_DV_TEST_TYPE 0 CI_DV_TEST_TYPE_L 0 CI_DV_TTYP_CHAR 0 CI_DV_TTYP_COMP 0 CI_DV_TTYP_ITEM 0 CI_DV_TTYP_MTR 0 CI_ENRL 0 CI_ENRL_ADDR 0 CI_ENRL_CAN_RSN 0 CI_ENRL_CAN_RSN_L 0 CI_ENRL_CBK_RSN 0 CI_ENRL_CBK_RSN_L 0 CI_ENRL_FLD 0 CI_ENRL_K 0 CI_ENRL_LOG 0 CI_ENRL_PER_ID 0 CI_ENRL_PER_NM 0 CI_ENRL_PER_PHN 0 CI_ENV_REF 0 CI_ENV_REF_L 0 CI_FA 0 CI_FAC_LVL_1 0 CI_FAC_LVL_1_2 0 CI_FAC_LVL_1_L 0 CI_FAC_LVL_2 0 CI_FAC_LVL_2_3 0 CI_FAC_LVL_2_L 0 CI_FAC_LVL_3 0 CI_FAC_LVL_3_L 0 CI_FAC_LVL_NAME 0 CI_FAC_LVL_NAME_L 0 CI_FAPR_FATY 0 CI_FAPR_TMPL 0 CI_FA_CAN_RSN 0 CI_FA_CAN_RSN_L 0 CI_FA_CHAR 0 CI_FA_CMPL_CTRL 0 CI_FA_K 0 CI_FA_LOG 0 CI_FA_REM 0 CI_FA_REM_ALG 0 CI_FA_REM_CD 0 CI_FA_REM_CD_L 0 CI_FA_REM_EXC 0 CI_FA_REM_EXP 0 CI_FA_RESCHED_RSN 0 CI_FA_RESCHED_RSN_L 0 CI_FA_STAGE_UP 0 CI_FA_STEP 0 CI_FA_STEP_TYPE 0 CI_FA_STEP_TYPE_L 0 CI_FA_STGUP_CHAR 0 CI_FA_STGUP_EXC 0 CI_FA_STGUP_REM 0 CI_FA_STP_STGUP 0 CI_FA_TYPE 0 CI_FA_TYPE_CHAR 0 CI_FA_TYPE_L 0 CI_FA_TYPE_PROF 0 CI_FA_TYPE_PROF_L 0 CI_FK_REF 497 CI_FK_REF_L 470 CI_FO 0 CI_FO_K 0 CI_FO_STG_DWN 0 CI_FREQ 6 CI_FREQ_L 6 CI_FS_CL 0 CI_FS_CL_DFLT 0 CI_FS_CL_L 0 CI_FS_CTRL 0 CI_FS_DGRP 0 CI_FS_OP_AREA 0 CI_FT 45720323 CI_FT_GL 88055352 CI_FT_K 44373229 CI_FT_PROC 24894544 CI_FUNC 0 CI_FUNC_FLD 0 CI_FUNC_FLD_L 0 CI_FUNC_L 0 CI_FUND 0 CI_FUND_L 0 CI_GEO_DFLT_SVC 0 CI_GEO_TYPE 4 CI_GEO_TYPE_L 4 CI_GEO_TYP_DFLT 0 CI_GL_DIVISION 1 CI_GL_DIVISION_L 1 CI_HI_LO_FACTOR 0 CI_ID_TYPE 8 CI_ID_TYPE_L 8 CI_INSTALL_ALG 52 CI_INSTALL_MSG 1 CI_INSTALL_MSG_L 1 CI_INSTALL_PROD 3 CI_INTV_DATA 0 CI_INTV_DATA_SET 0 CI_INTV_DATA_SET_K 0 CI_INTV_DS_EXC 0 CI_INTV_PF 0 CI_INTV_PFRELTY 0 CI_INTV_PFRELTY_L 0 CI_INTV_PF_ALG 0 CI_INTV_PF_K 0 CI_INTV_PF_L 0 CI_INTV_PF_TYP 0 CI_INTV_PF_TYP_L 0 CI_INTV_REG_ALG 0 CI_INTV_REG_TYP 4 CI_INTV_REG_TYP_L 4 CI_INTV_VAL 0 CI_INTV_VAL_SET 0 CI_INTV_VAL_SET_K 0 CI_ITEM 0 CI_ITEM_CHAR 0 CI_ITEM_EQ 0 CI_ITEM_K 0 CI_ITEM_LOC_HIS 0 CI_ITEM_LOC_HIS_K 0 CI_ITEM_SQ_EST 0 CI_ITEM_STK_LOC 0 CI_ITEM_TYPE 2 CI_ITEM_TYPE_EQ 0 CI_ITEM_TYPE_L 2 CI_ITEM_TYP_CHA 0 CI_LANDLORD 0 CI_LANDLORD_K 0 CI_LANGUAGE 1 CI_LETTER_TMPL 109 CI_LETTER_TMPL_L 109 CI_LL_DETAIL 0 CI_LOOKUP_FIELD 1084 CI_LOOKUP_VAL 5734 CI_LOOKUP_VAL_L 5743 CI_MATCH_EVT 0 CI_MATCH_EVT_K 0 CI_MATCH_TYPE 0 CI_MATCH_TYPE_L 0 CI_MD_ATT_TY 109 CI_MD_AT_DTL 108 CI_MD_AT_DTL_L 108 CI_MD_CONST 4426 CI_MD_CONST_FLD 6551 CI_MD_CTL 20 CI_MD_CTL_L 20 CI_MD_CTL_TMPL 225 CI_MD_ELTY 36 CI_MD_ELTY_AT 489 CI_MD_ELTY_L 36 CI_MD_FLD 15399 CI_MD_FLD_L 15381 CI_MD_LOOKUP_F 12 CI_MD_MENU 119 CI_MD_MENU_IMOD 1218 CI_MD_MENU_ITEM 1358 CI_MD_MENU_ITEM_L 1355 CI_MD_MENU_L 119 CI_MD_MENU_LINE 997 CI_MD_MENU_LINE_L 997 CI_MD_MENU_MOD 0 CI_MD_MO 396 CI_MD_MO_ALG 106 CI_MD_MO_L 396 CI_MD_MO_OPT 1488 CI_MD_MO_TBL 1365 CI_MD_MO_WRK 0 CI_MD_MSG 51 CI_MD_MSG_L 51 CI_MD_NAV 4359 CI_MD_PDF 18 CI_MD_PDF_VAL 58 CI_MD_PRG_COM 10875 CI_MD_PRG_ELEM 33446 CI_MD_PRG_EL_AT 17706 CI_MD_PRG_LOC 652 CI_MD_PRG_MOD 487 CI_MD_PRG_SEC 6325 CI_MD_PRG_SQL 18174 CI_MD_PRG_TAB 885 CI_MD_PRG_VAR 71386 CI_MD_RPT 0 CI_MD_RPT_L 0 CI_MD_RPT_LBL 0 CI_MD_RPT_PARM 0 CI_MD_RPT_PARM_L 0 CI_MD_SO 14 CI_MD_SOCG 36 CI_MD_SOCG_FLD 60 CI_MD_SOCG_FLDAT 12 CI_MD_SOCG_L 36 CI_MD_SOCG_SORT 20 CI_MD_SO_L 14 CI_MD_SO_RSFLD 79 CI_MD_SO_RSFLDAT 8 CI_MD_SRC_TYPE 8 CI_MD_SRC_TYPE_L 8 CI_MD_SVC 2574 CI_MD_SVC_L 2565 CI_MD_SVC_PRG 2237 CI_MD_TAB_MOD 52 CI_MD_TBL 1741 CI_MD_TBL_FLD 11994 CI_MD_TBL_FLD_L 11994 CI_MD_TBL_L 1693 CI_MD_TMPL 61 CI_MD_TMPL_ELTY 409 CI_MD_TMPL_L 61 CI_MD_TMPL_VAR 2484 CI_MD_TMPL_VAR_L 2135 CI_MD_TOOLREP_XML 0 CI_MD_TOOL_REP 0 CI_MD_VAR 557 CI_MD_VAR_DTL 600 CI_MD_VAR_DTL_L 600 CI_MD_WRK_TBL 0 CI_MD_WRK_TBLFLD 0 CI_MD_WRK_TBL_L 0 CI_MEVT_CAN_RSN 0 CI_MEVT_CAN_RSN_L 0 CI_MFG 1 CI_MFG_L 1 CI_MKTMSG_TYPE 0 CI_MKTMSG_TYPE_ALG 0 CI_MKTMSG_TYPE_CHAR 0 CI_MKTMSG_TYPE_L 0 CI_MODEL 2 CI_MODEL_L 2 CI_MPL_EXC 0 CI_MR 906997 CI_MRR_STGE_UP 0 CI_MR_CHAR 0 CI_MR_CYC 457 CI_MR_CYC_L 457 CI_MR_INSTR 0 CI_MR_INSTR_L 0 CI_MR_K 906971 CI_MR_REM 0 CI_MR_REM_ACTN 0 CI_MR_REM_BMSG 0 CI_MR_REM_EXCP 0 CI_MR_RTE 457 CI_MR_RTE_CHAR 0 CI_MR_RTE_L 457 CI_MR_RTE_TYPE 1 CI_MR_RTE_TYPE_L 1 CI_MR_SCHED 0 CI_MR_SCHED_RTE 0 CI_MR_SOURCE 0 CI_MR_SOURCE_L 0 CI_MR_STAGE_DWN 0 CI_MR_STAGE_UP 0 CI_MR_STGUP_CHAR 0 CI_MR_STGUP_EXC 0 CI_MR_WARN 0 CI_MR_WARN_L 0 CI_MSG 13279 CI_MSG_CATEGORY 66 CI_MSG_CATEGORY_L 66 CI_MSG_L 13278 CI_MSG_LOG 19265217 CI_MSG_LOGPARM 42509464 CI_MSG_LOG_PK 11 CI_MTR 864260 CI_MTR_CFGTY_RL 31 CI_MTR_CHAR 0 CI_MTR_CONFIG 864032 CI_MTR_CONFIG_K 864035 CI_MTR_CONFIG_TY 19 CI_MTR_CONFIG_TY_L 19 CI_MTR_EQ 0 CI_MTR_ID 2 CI_MTR_ID_TYPE 1 CI_MTR_ID_TYPE_L 1 CI_MTR_K 864260 CI_MTR_LOC 0 CI_MTR_LOC_HIS 0 CI_MTR_LOC_HIS_K 0 CI_MTR_LOC_L 0 CI_MTR_STK_LOC 0 CI_MTR_TYPE 7 CI_MTR_TYPE_EQ 0 CI_MTR_TYPE_L 7 CI_MTR_TYP_CHAR 2 CI_MTR_TY_CFGTY 18 CI_MULT_ITEM 0 CI_NAV_OPT 2324 CI_NAV_OPT_CTXT 1767 CI_NAV_OPT_L 2324 CI_NAV_OPT_USG 3044 CI_NB_RULE 3 CI_NB_RULE_L 3 CI_NB_RULE_PARM 17 CI_NB_RULE_VER 3 CI_NB_SA 476989 CI_NB_SCHED_PAY 1088268 CI_NB_SCHED_PAY_261115 874 CI_NB_SCHED_PAY_K 1292438 CI_NB_SCHED_PAY_K_261115 770 CI_NCD 0 CI_NCD_TYPE 0 CI_NCD_TYPE_L 0 CI_NT_DNTY_CTXT 0 CI_NT_DWN 0 CI_NT_DWN_CHAR 0 CI_NT_DWN_CTXT 0 CI_NT_DWN_EXC 0 CI_NT_DWN_EXP 0 CI_NT_DWN_FORM 0 CI_NT_DWN_FORM_L 0 CI_NT_DWN_K 0 CI_NT_DWN_PROF 0 CI_NT_DWN_PROF_L 0 CI_NT_DWN_TYPE 0 CI_NT_DWN_TYPE_L 0 CI_NT_UP 0 CI_NT_UP_CHAR 0 CI_NT_UP_CTXT 0 CI_NT_UP_EXCP 0 CI_NT_UP_XSPL 0 CI_NT_UP_XTYPE 0 CI_NT_UP_XTYPE_L 0 CI_NT_XID 15 CI_NT_XID_L 15 CI_OD_EVT 0 CI_OD_EVT_DEP 0 CI_OD_EVT_TYPE 0 CI_OD_EVT_TYPE_ALG 0 CI_OD_EVT_TYPE_L 0 CI_OD_PROC 0 CI_OD_PROC_K 0 CI_OD_PROC_LOG 0 CI_OD_PROC_LOGPARM 0 CI_OD_PROC_OBJ 0 CI_OD_PROC_TMP 0 CI_OD_PROC_TMP_ALG 0 CI_OD_PROC_TMP_L 0 CI_OD_RESP 0 CI_OD_RESP_DEP 0 CI_OD_RULE_ALG 0 CI_OEVT_CAN_RSN 0 CI_OEVT_CAN_RSN_L 0 CI_OP_AREA 0 CI_OP_AREA_L 0 CI_PAY 11166029 CI_PAY_CAN_RSN 8 CI_PAY_CAN_RSN_L 8 CI_PAY_CHAR 17225 CI_PAY_EVENT 11168287 CI_PAY_EVENT_K 10604446 CI_PAY_EVT_CHAR 0 CI_PAY_EVT_EXCP 4193 CI_PAY_EXCP 811 CI_PAY_K 10602188 CI_PAY_METH 2 CI_PAY_METH_L 2 CI_PAY_SEG 13912035 CI_PAY_SEG_K 13912922 CI_PAY_SEG_TYPE 1 CI_PAY_SEG_TYPE_L 1 CI_PAY_ST 0 CI_PAY_TMPL 0 CI_PAY_TMPL_L 0 CI_PAY_TNDR 10604507 CI_PAY_TNDR_CHAR 0 CI_PAY_TNDR_K 10604507 CI_PAY_TNDR_ST 413558 CI_PAY_TNDR_ST_091215 114 CI_PAY_TNDR_ST_271015 87408 CI_PAY_TNDR_ST_BACKUP 77959 CI_PAY_TNDR_ST_CHAR 17073 CI_PER 625987 CI_PER_ADDR_OVRD 11811 CI_PER_ADDR_SEAS 9 CI_PER_CHAR 487822 CI_PER_ID 1170837 CI_PER_K 625987 CI_PER_NAME 629751 CI_PER_PER 0 CI_PER_PHONE 754675 CI_PER_REL_TYPE 0 CI_PER_REL_TYPE_L 0 CI_PEVT_DST_DTL 0 CI_PEVT_DTL_ST 0 CI_PFRELTY_PFTY 0 CI_PHONE_TYPE 2 CI_PHONE_TYPE_L 2 CI_PKG 0 CI_PKG_CRT 0 CI_PKG_CRT_GRP 0 CI_PKG_CRT_GRP_L 0 CI_PKG_FLD_OVRD 0 CI_PKG_FLD_OVRD_L 0 CI_PKG_INSTR 0 CI_PKG_INSTR_L 0 CI_PKG_K 0 CI_PKG_L 0 CI_PKG_SA_TYPE 0 CI_PORTAL 169 CI_PORTAL_L 169 CI_PORTAL_ZONE 376 CI_POST_DFLT 0 CI_PP 22013 CI_PP_K 22013 CI_PP_SCHED_PAY 144054 CI_PP_TYPE 1 CI_PP_TYPE_L 1 CI_PREM 459500 CI_PREM_CHAR 1 CI_PREM_GEO 53 CI_PREM_K 459500 CI_PREM_TYPE 2 CI_PREM_TYPE_L 2 CI_PRM_ALT_ADDR 0 CI_PRM_ALT_ADDR_K 0 CI_PROP_DCL_RSN 0 CI_PROP_DCL_RSN_L 0 CI_PROTOCOL 0 CI_PROTOCOL_L 0 CI_QTE_RTE_TYPE 0 CI_QTE_RTE_TYPE_L 0 CI_QUOTE 0 CI_QUOTE_DTL 0 CI_QUOTE_DTL_K 0 CI_QUOTE_K 0 CI_QUOTE_RTG 0 CI_RC 0 CI_RC_CHAR 0 CI_RC_CRT 0 CI_RC_CRT_GRP 0 CI_RC_CRT_GRP_L 0 CI_RC_GL_DST 0 CI_RC_L 0 CI_RC_XREF 0 CI_RDR_TMPL 0 CI_READER_REM 0 CI_READER_REM_L 0 CI_READ_OUT_TYP 1 CI_READ_OUT_TYP_L 1 CI_REBATE_CLAIM 0 CI_REBATE_CLAIM_CHAR 0 CI_REBATE_CLAIM_K 0 CI_REBATE_CLAIM_LOG 0 CI_REBATE_CLAIM_LOG_PARM 0 CI_REBATE_DEFN 0 CI_REBATE_DEFN_L 0 CI_REBATE_LINE 0 CI_REBATE_LINE_CHAR 0 CI_REG 924545 CI_REG_CHAR 1410611 CI_REG_DATA 0 CI_REG_DATA_SET 0 CI_REG_DATA_SET_K 0 CI_REG_DS_EXC 0 CI_REG_DS_EXP 0 CI_REG_K 924545 CI_REG_READ 963930 CI_REG_READ_K 963995 CI_REG_RULE 0 CI_REG_RULE_L 0 CI_REP 0 CI_REPL_ACCT 0 CI_REPL_CNTL 0 CI_REP_L 0 CI_RETIRE_RSN 1 CI_RETIRE_RSN_L 1 CI_REV_CL 3 CI_REV_CL_L 3 CI_ROLE 56 CI_ROLE_L 54 CI_ROLE_USER 13163 CI_ROOT_DIFF 0 CI_ROOT_INSTR 0 CI_ROOT_INSTR_K 0 CI_ROOT_OBJ 0 CI_ROOT_OBJ_EXC 0 CI_ROOT_OBJ_EXP 0 CI_ROOT_OBJ_K 0 CI_ROOT_OBJ_PK 0 CI_RPT_OPTION 0 CI_RR_STAGE_UP 0 CI_RS 479 CI_RS_BMSG 0 CI_RS_L 469 CI_RS_MTR_CFGTY 779 CI_RS_REG_RULE 0 CI_RS_SQ_RULE 0 CI_RS_SUB_RS 0 CI_RV 0 CI_RV_L 0 CI_SA 2514839 CI_SATY_ALG 67 CI_SATY_COPTY 0 CI_SATY_SARELTY 0 CI_SATY_TMAPRTY 0 CI_SAT_ADJ_PROF 41 CI_SAT_NB_RULE 3 CI_SAT_PFRELTY 0 CI_SA_CHAR 3546452 CI_SA_CHAR_TMP 1173 CI_SA_CONTERM 61337 CI_SA_CONT_QTY 0 CI_SA_COP 0 CI_SA_COP_K 0 CI_SA_COP_OVRD 0 CI_SA_INTV_PF 0 CI_SA_K 2514839 CI_SA_MSG 0 CI_SA_NB_PARM 2274455 CI_SA_RCHG_HIST 0 CI_SA_REL 0 CI_SA_REL_K 0 CI_SA_REL_TYPE 0 CI_SA_REL_TYPE_L 0 CI_SA_RS_HIST 1898567 CI_SA_SP 1895397 CI_SA_SP_CHAR 0 CI_SA_SP_FA 0 CI_SA_SP_K 1895403 CI_SA_SP_TYPE 8 CI_SA_TC 0 CI_SA_TOU_MAP 0 CI_SA_TYPE 18 CI_SA_TYPE_BC 0 CI_SA_TYPE_CHAR 15 CI_SA_TYPE_L 18 CI_SA_TYPE_RS 466 CI_SCM 338125 CI_SCMTY_SATY 0 CI_SCMTY_SUBCAT 0 CI_SCMTY_SUBCAT_L 0 CI_SCM_ACCT 338127 CI_SCM_CHAR 56612 CI_SCM_K 338125 CI_SCM_NCTV_RSN 5 CI_SCM_NCTV_RSN_L 5 CI_SCM_TYPE 1 CI_SCM_TYPE_ALG 0 CI_SCM_TYPE_L 1 CI_SCR 1645 CI_SCR_CRT 0 CI_SCR_CRT_GRP 0 CI_SCR_CRT_GRP_L 0 CI_SCR_DA 8183 CI_SCR_FLD_MAP 0 CI_SCR_L 1645 CI_SCR_PRMPT 145 CI_SCR_PRMPT_L 145 CI_SCR_STEP 7835 CI_SCR_STEP_L 7835 CI_SC_AUTH_LVL 14 CI_SC_AUTH_LVL_L 14 CI_SC_EVT 9837022 CI_SC_EVTTY_ALG 2 CI_SC_EVT_FT 4257866 CI_SC_EVT_FT_K 4257866 CI_SC_EVT_K 9589361 CI_SC_EVT_TYPE 8 CI_SC_EVT_TYPE_L 8 CI_SC_TYPE 8 CI_SC_TYPE_L 8 CI_SEAS_SHIFT 0 CI_SEAS_TM_SHIFT 0 CI_SEAS_TM_SHIFT_L 0 CI_SEQ 5 CI_SEV_CRIT 0 CI_SEV_EVT 0 CI_SEV_EVT_CC 0 CI_SEV_EVT_DEP 0 CI_SEV_EVT_FA 0 CI_SEV_EVT_TYPE 1 CI_SEV_EVT_TYPE_L 1 CI_SEV_PROC 0 CI_SEV_PROC_K 0 CI_SEV_PROC_TMP 1 CI_SEV_PROC_TMP_L 1 CI_SEV_RESP 1 CI_SEV_RESP_DEP 0 CI_SIC 0 CI_SIC_L 0 CI_SP 863471 CI_SPR 0 CI_SPR_BMSG 0 CI_SPR_L 0 CI_SPR_POST 0 CI_SPR_SARELTY 0 CI_SPR_VALID 0 CI_SPTY_ITEMTY 0 CI_SPTY_MTRTY 7 CI_SP_CHAR 6427022 CI_SP_EQ 0 CI_SP_GEO 856588 CI_SP_ITEM_EVT 0 CI_SP_ITEM_HIST 0 CI_SP_ITEM_HIST_K 0 CI_SP_K 863471 CI_SP_MTR_EVT 890921 CI_SP_MTR_HIST 860962 CI_SP_MTR_HIST_K 863508 CI_SP_MULT_ITEM 9 CI_SP_OP_AREA 0 CI_SP_RTE 0 CI_SP_RTE_CFG 0 CI_SP_TYPE 2 CI_SP_TYPE_CHAR 0 CI_SP_TYPE_EQ 0 CI_SP_TYPE_L 2 CI_SQI 8 CI_SQI_L 8 CI_SQ_RULE 0 CI_SQ_RULE_L 0 CI_SS_ADDR_OVRD 836 CI_SS_OPT 391 CI_SS_OPT_COP 0 CI_SS_OPT_IP 0 CI_SS_OPT_L 391 CI_SS_OPT_TC 0 CI_SS_OPT_TMAP 0 CI_SS_PHONE_OVRD 722 CI_STATE 0 CI_STATE_L 0 CI_STK_LOC 0 CI_STK_LOC_CHAR 0 CI_STK_LOC_L 0 CI_STM 335601 CI_STM_CNST 762494 CI_STM_CNST_DTL 1558524 CI_STM_CNST_DTL_K 1558524 CI_STM_CNST_K 762494 CI_STM_CYC 376 CI_STM_CYC_L 376 CI_STM_CYC_SCH 511 CI_STM_DTL 1686667 CI_STM_DTL_K 1686667 CI_STM_K 335718 CI_STM_RTE_TY 6 CI_STM_RTE_TY_L 6 CI_SVC_RTE_STG_DWN 0 CI_SVC_RTE_STG_DWN_K 0 CI_SVC_TYPE 3 CI_SVC_TYPE_L 3 CI_SVC_TYP_DFLT 0 CI_SYSDATA_LOG 0 CI_TAX_EX_TYPE 0 CI_TAX_EX_TYPE_L 0 CI_TC 0 CI_TC_L 0 CI_TD_DRLKEY 7320555 CI_TD_DRLKEY_TY 405 CI_TD_ENTRY 7182251 CI_TD_ENTRY_CHA 9053903 CI_TD_ENTRY_K 7050341 CI_TD_EX_LIST 2 CI_TD_LOG 10940691 CI_TD_MSG_PARM 9799603 CI_TD_SRTKEY 18233902 CI_TD_SRTKEY_TY 796 CI_TD_SRTKEY_TY_L 796 CI_TD_TYPE 381 CI_TD_TYPE_ALG 2 CI_TD_TYPE_CHAR 3 CI_TD_TYPE_L 381 CI_TD_VAL_ROLE 537 CI_TENDER_TYPE 18 CI_TENDER_TYPE_L 18 CI_THRD_PTY 0 CI_THRD_PTY_L 0 CI_TIME_ZONE 1 CI_TIME_ZONE_L 1 CI_TMAP_COM_CAL 0 CI_TMAP_COM_DAY 0 CI_TMAP_COM_WK 0 CI_TMAP_REL 0 CI_TMAP_RELTY 0 CI_TMAP_RELTY_L 0 CI_TMAP_TMPL 0 CI_TMAP_TMPL_L 0 CI_TMAP_TYPE 0 CI_TMAP_TYPE_L 0 CI_TMAP_TYP_ALG 0 CI_TNDR_CTL 2812 CI_TNDR_CTL_CHAR 0 CI_TNDR_CTL_K 2812 CI_TNDR_CTL_ST 2143 CI_TNDR_CTL_ST_091215 1 CI_TNDR_CTL_ST_271015 462 CI_TNDR_CTL_ST_BACKUP 391 CI_TNDR_DEP 5988 CI_TNDR_DEP_K 5988 CI_TNDR_END_BAL 3508 CI_TNDR_SRCE 10 CI_TNDR_SRCE_L 10 CI_TNDR_ST_EXCP 40 CI_TOS 0 CI_TOS_CAN_RSN 0 CI_TOS_CAN_RSN_L 0 CI_TOS_CE 0 CI_TOS_CHAR 0 CI_TOS_K 0 CI_TOS_SA 0 CI_TOS_TYPE 0 CI_TOS_TYPE_CE 0 CI_TOS_TYPE_L 0 CI_TOU 5 CI_TOU_BF_VAL 0 CI_TOU_CONT_VAL 0 CI_TOU_DATA 0 CI_TOU_DATA_SET 0 CI_TOU_DATA_SET_K 0 CI_TOU_DS_EXC 0 CI_TOU_DS_EXP 0 CI_TOU_GRP 0 CI_TOU_GRP_L 0 CI_TOU_GRP_TOU 0 CI_TOU_L 5 CI_TOU_MAP 0 CI_TOU_MAP_K 0 CI_TOU_MAP_L 0 CI_TREND 0 CI_TREND_AREA 1 CI_TREND_AREA_L 1 CI_TREND_CL 1 CI_TREND_CL_L 1 CI_TRG 0 CI_TRG_FLD 0 CI_TST_COMP_TYP 0 CI_TST_COMP_TYP_L 0 CI_TST_RES_TYP 0 CI_TST_RES_TYP_L 0 CI_TURN_IN 0 CI_TURN_IN_K 0 CI_UA 0 CI_UATY_TOSTY 0 CI_UA_CHAR 0 CI_UA_K 0 CI_UA_PER 0 CI_UA_TYPE 0 CI_UA_TYPE_ALG 0 CI_UA_TYPE_L 0 CI_UI_ZONE 66 CI_UOM 7 CI_UOM_L 7 CI_USR_GRP_SC 68 CI_USR_NAV_LINK 30 CI_USR_PORTAL 113 CI_USR_SCR 0 CI_USR_ZONE 315 CI_UT_INSTL 547 CI_UT_INSTL_DTL 1067 CI_VAL_ERR 4359 CI_VAL_FK_ERR 44351 CI_VAL_SUB_SATY 0 CI_WFM 26 CI_WFM_L 26 CI_WFM_MSG 0 CI_WFM_OPT 569 CI_WF_EVT 0 CI_WF_EVT_CHAR 0 CI_WF_EVT_CTXT 0 CI_WF_EVT_DEP 0 CI_WF_EVT_EXC 0 CI_WF_EVT_EXP 0 CI_WF_EVT_TYPE 0 CI_WF_EVT_TYPE_L 0 CI_WF_PP 0 CI_WF_PP_L 0 CI_WF_PP_NT 0 CI_WF_PP_NT_CRT 0 CI_WF_PROC 0 CI_WF_PROC_CHAR 0 CI_WF_PROC_CTXT 0 CI_WF_PROC_K 0 CI_WF_PROC_MSGP 0 CI_WF_PROC_SCHED 0 CI_WF_PROC_SCHED_K 0 CI_WF_PROC_TMPL 0 CI_WF_PROC_TMPL_L 0 CI_WF_RESP 0 CI_WF_RESP_DEP 0 CI_WO_CNTL 1 CI_WO_CNTL_L 1 CI_WO_CRIT 4 CI_WO_DEBT_CL 2 CI_WO_DEBT_CL_L 2 CI_WO_EVT 1234736 CI_WO_EVT_CC 191604 CI_WO_EVT_TYP 12 CI_WO_EVT_TYP_L 13 CI_WO_PROC 892945 CI_WO_PROC_K 892945 CI_WO_PROC_SA 1351733 CI_WO_PROC_TMPL 4 CI_WO_PROC_TMPL_L 4 CI_WO_RESP 13 CI_XAI_ADAPTER 10 CI_XAI_ADAPTER_L 10 CI_XAI_CLASS 27 CI_XAI_CLASS_L 27 CI_XAI_DWN 0 CI_XAI_DWN_EXC 0 CI_XAI_DWN_EXP 0 CI_XAI_ENV_HNDL 6 CI_XAI_ENV_HNDL_L 6 CI_XAI_EXECUTER 4 CI_XAI_EXECUTER_L 4 CI_XAI_FORMAT 21 CI_XAI_FORMAT_L 21 CI_XAI_IN_SVC 199 CI_XAI_IN_SVC_L 204 CI_XAI_JDBC_CON 0 CI_XAI_JDBC_CON_L 0 CI_XAI_JMS_CON 11 CI_XAI_JMS_CON_L 11 CI_XAI_JMS_Q 19 CI_XAI_JMS_Q_L 19 CI_XAI_JMS_TPC 0 CI_XAI_JMS_TPC_L 0 CI_XAI_JNDI_SVR 6 CI_XAI_JNDI_SVR_L 6 CI_XAI_OPTION 38 CI_XAI_RCVR 4 CI_XAI_RCVR_CTX 0 CI_XAI_RCVR_L 4 CI_XAI_RCVR_RGRP 0 CI_XAI_RCVR_RSP 4 CI_XAI_RGRP 0 CI_XAI_RGRP_ATT 0 CI_XAI_RGRP_L 0 CI_XAI_ROUTING 0 CI_XAI_RT_TYPE 0 CI_XAI_RT_TYPE_L 0 CI_XAI_RULE 0 CI_XAI_SENDER 56 CI_XAI_SENDER_L 54 CI_XAI_SNDR_CTX 236 CI_XAI_SVC_PARM 0 CI_XML_STGCTL_P 0 CI_XML_STGUP 231668 CI_XML_STGUPEXP 233794 CI_XML_STGUP_EX 231666 CI_XML_STG_CTL 231668 CI_ZONE 1195 CI_ZONE_HDL 17 CI_ZONE_HDL_L 17 CI_ZONE_HDL_PRM 1277 CI_ZONE_HDL_PRM_L 1277 CI_ZONE_L 1195 CI_ZONE_PRM 190964 CMP3$115009 47928 CMP3$115075 53452 CMP3$115148 26731 CMP3$115175 36199 CMP3$217931 81391 CMP3$218053 27503 CMP3$218094 32082 CMP3$218112 59626 CMP3$218130 5378 CMP3$218183 43413 CM_ACCT_STG 1071 CM_APAY_CLR_STG_BACK 562 CM_APAY_CLR_STG_K_BACK 562 CM_BILL_EXCP_BACKUP 774 CM_BILL_ROUTING 22081 CM_BSEG_BACKUP_PENDING 774 CM_CASE_CHAR_28SEP15 5379 CM_COLL_PROC_SA_TMP 22562 CM_CUST_TIL 8907978 CM_CUST_TIL_K 9014754 CM_DD_FILE 643771 CM_DD_FILE_CHAR 0 CM_DD_FILE_K 643771 CM_DD_FILE_LOG 1758190 CM_DD_FILE_LOG_PARM 1818767 CM_DEP_CTL_ST_28SEP15 1 CM_DEP_CTL_ST_F0979098 9 CM_DEP_CTL_ST_F0979098_2 3 CM_FT_BACKUP_COMPLETED 860 CM_JUL_END_BILL_CYC_TMP 12890 CM_LOSS_BILLS 16746 CM_LOSS_FLW_ACCTS 24311 CM_LOSS_FLW_AC_BILL_CYC_TMP 11600 CM_MAR_END_BILL_CYC_TMP 10050 CM_MAY_END_BILL_CYC_TMP 5561 CM_MOVED_SA 0 CM_NB_SCHED_PAY 28501 CM_NB_SCHED_PAY_BACK 29458 CM_NB_SCHED_PAY_LOG 556 CM_NB_SCHED_PAY_LOG_BACK 127 CM_PAY_BACK 562 CM_PAY_EVT_BACK 562 CM_PAY_EVT_K_BACK 562 CM_PAY_EVT_ROLLBACK 0 CM_PAY_K_BACK 562 CM_PAY_TNDR_BACK 562 CM_PAY_TNDR_K_BACK 562 CM_PAY_TNDR_ST_28SEP15 487 CM_PAY_TNDR_ST_F0979098 1325 CM_PAY_TNDR_ST_F0979098_2 679 CM_PROD_TIL 467 CM_PROD_TIL_CHAR 1371 CM_PROD_TIL_DETAILS 10480 CM_PROD_TIL_DETAILS_291015 4676 CM_PROD_TIL_DETAILS_K 10726 CM_PROD_TIL_DETAILS_K_291015 4907 CM_PROD_TIL_K 457 CM_PROD_TIL_LOG 3961 CM_PROD_TIL_LOG_291015 1853 CM_PROD_TIL_LOG_PARM 4428 CM_PROD_TIL_LOG_PARM_291015 2345 CM_RESEND_OUTMSG 540 CM_RESET_NBB_RENEW_EXPIRE_DATE 2483 CM_SP_MTR_HIST_16102015 3 CM_SYNC_ID 370000 CM_TMP_ACCT_BALANCES 597780 CM_TMP_ACCT_ISSUES 124498 CM_TMP_ACCT_NOT_BILLABLE_IT15 22560 CM_TMP_CRM_CCB_BALANCE 241932 CM_TMP_CRM_CCB_BALANCE_2 241943 CM_TMP_PSEG_NOSA 738 CM_TMP_REMOVED_NB_SA 220507 CM_TMP_UNASSIGNED_AD 0 CM_TMP_UNBAL_AMI_FINDINGS 5039 CM_TMP_UNDISTRIBUTED_PS 0 CM_TMP_VAL_ERR 48898 CM_TNDR_CTL_ST_28SEP15 1 CM_TNDR_CTL_ST_F0979098 9 CM_TNDR_CTL_ST_F0979098_2 3 CRM_COLLECTIONS 0 DATA_CLEANSE_CRM 1553 DATA_CLEANSE_ZOMG 1366 DUP_SP_ACCT 2157 DUP_SP_ACCTS 0 F1_ATTACHMENT 85828 F1_ATTACHMENT_CHAR 282712 F1_BKT_CONFIG 11 F1_BKT_CONFIG_L 11 F1_BKT_CONFIG_REL_OBJ 0 F1_BKT_CONFIG_VAL 45 F1_BKT_CONFIG_VAL_L 45 F1_BNDL 3 F1_BNDL_CHAR 0 F1_BNDL_ENTITY 21 F1_BNDL_K 3 F1_BNDL_LOG 6 F1_BNDL_LOG_PARM 6 F1_BUS_EVT_LOG 0 F1_BUS_EVT_LOG_CHAR 0 F1_BUS_EVT_LOG_K 0 F1_BUS_EVT_LOG_MSG_PARM 0 F1_BUS_OBJ 906 F1_BUS_OBJ_ALG 216 F1_BUS_OBJ_L 906 F1_BUS_OBJ_OPT 746 F1_BUS_OBJ_STATUS 566 F1_BUS_OBJ_STATUS_ALG 632 F1_BUS_OBJ_STATUS_L 566 F1_BUS_OBJ_STATUS_OPT 168 F1_BUS_OBJ_STATUS_RSN 10 F1_BUS_OBJ_STATUS_RSN_CHAR 2 F1_BUS_OBJ_STATUS_RSN_L 10 F1_BUS_OBJ_TR_RULE 857 F1_BUS_OBJ_TR_RULE_L 871 F1_BUS_SVC 1010 F1_BUS_SVC_L 1009 F1_DATA_AREA 545 F1_DATA_AREA_L 545 F1_DB_OBJECTS_REPO 3954 F1_EXTSYS_OUTMSG_PROF 51 F1_EXT_LOOKUP_VAL 1471 F1_EXT_LOOKUP_VAL_L 1472 F1_FACT 949980 F1_FACT_CHAR 5674922 F1_FACT_K 949817 F1_FACT_LOG 13704165 F1_FACT_LOG_PARM 17002307 F1_GENERIC_GTT F1_GEN_PROC 0 F1_GEN_PROC_K 0 F1_GNRL_AUDIT 0 F1_GNRL_AUDIT_CHAR 0 F1_GNRL_AUDIT_K 0 F1_GNRL_AUDIT_VAL 0 F1_INSTALLATION 1 F1_IWS_ANN 1 F1_IWS_ANN_CHAR 0 F1_IWS_ANN_L 1 F1_IWS_ANN_PARM 2 F1_IWS_ANN_TYPE 1 F1_IWS_ANN_TYPE_CHAR 0 F1_IWS_ANN_TYPE_L 1 F1_IWS_ANN_TYPE_PARM 2 F1_IWS_ANN_TYPE_PARM_L 2 F1_IWS_SVC 5 F1_IWS_SVC_ANN 0 F1_IWS_SVC_CHAR 0 F1_IWS_SVC_L 5 F1_IWS_SVC_LOG 0 F1_IWS_SVC_LOG_PARM 0 F1_IWS_SVC_OPER 5 F1_IWS_SVC_OPER_L 0 F1_KEY_HASH 0 F1_MANAG_CONTENT 15 F1_MANAG_CONTENT_L 15 F1_MAP 724 F1_MAP_L 723 F1_MAP_OVRD 0 F1_MD_DB_OBJ 6 F1_MIGR_DATA_ST 260 F1_MIGR_DATA_ST_ALG 0 F1_MIGR_DATA_ST_K 237 F1_MIGR_DATA_ST_LOG 1480 F1_MIGR_DATA_ST_LOG_PARM 1334 F1_MIGR_DATA_ST_TBL 0 F1_MIGR_OBJ 320650 F1_MIGR_OBJ_ALG 295 F1_MIGR_OBJ_CLOB 2350 F1_MIGR_OBJ_K 318237 F1_MIGR_OBJ_LOG 334382 F1_MIGR_OBJ_LOG_PARM 333635 F1_MIGR_OBJ_SQL 35576 F1_MIGR_PLAN 231 F1_MIGR_PLAN_INSTR 545 F1_MIGR_PLAN_INSTR_ALG 1 F1_MIGR_PLAN_INSTR_L 544 F1_MIGR_PLAN_L 233 F1_MIGR_REQ 25 F1_MIGR_REQ_INSTR 437 F1_MIGR_REQ_INSTR_ENTITY 6 F1_MIGR_REQ_INSTR_L 437 F1_MIGR_REQ_L 24 F1_MIGR_TRANS 19142 F1_MIGR_TRANS_K 17521 F1_MIGR_TRANS_LOG 16 F1_MIGR_TRANS_LOG_PARM 0 F1_MST_CONFIG 5 F1_OBJ_REV 0 F1_OBJ_REV_CHAR 0 F1_OBJ_REV_LOG 0 F1_OBJ_REV_LOG_PARM 0 F1_OUTMSG 13359768 F1_OUTMSG_ERRPARM 1994045 F1_OUTMSG_K 13147326 F1_OUTMSG_TYPE 43 F1_OUTMSG_TYPE_L 43 F1_REQ 0 F1_REQ_CHAR 0 F1_REQ_K 0 F1_REQ_LOG 0 F1_REQ_LOG_PARM 0 F1_REQ_TYPE 0 F1_REQ_TYPE_L 0 F1_REQ_TYPE_LOG 0 F1_REQ_TYPE_LOG_PARM 0 F1_SCHEMA 4226 F1_SVC_TASK 2499086 F1_SVC_TASK_CHAR 5417377 F1_SVC_TASK_K 2438188 F1_SVC_TASK_LOG 10400727 F1_SVC_TASK_LOG_PARM 9146684 F1_SVC_TASK_REL_OBJ 4553866 F1_SVC_TASK_TYPE 23 F1_SVC_TASK_TYPE_CHAR 8 F1_SVC_TASK_TYPE_L 23 F1_SYNC_REQ 29307741 F1_SYNC_REQ_CHAR 0 F1_SYNC_REQ_EXTRACT 0 F1_SYNC_REQ_IN 0 F1_SYNC_REQ_IN_CHAR 0 F1_SYNC_REQ_IN_EXCP 0 F1_SYNC_REQ_IN_EXCP_PARM 0 F1_SYNC_REQ_IN_K 0 F1_SYNC_REQ_IN_LOG 0 F1_SYNC_REQ_IN_LOG_PARM 0 F1_SYNC_REQ_IN_REL_OBJ 0 F1_SYNC_REQ_K 32288859 F1_SYNC_REQ_LOG 128127323 F1_SYNC_REQ_LOG_PARM 100495681 F1_TSPACE_ENTRY 5712 F1_WEB_SVC 0 F1_WEB_SVC_CHAR 0 F1_WEB_SVC_GTT F1_WEB_SVC_L 0 F1_WEB_SVC_LOG 0 F1_WEB_SVC_LOG_PARM 0 F1_WEB_SVC_OPERATIONS 0 FACT_TEST 137296 FI_TEST 3803212 GTT_CLBDSYNC JAM_FT_BAL_OLD_ACCT_GOLIVE_STG 215850 JAM_FT_OLD_ACCT_GOLIVE_STG 10290107 JP_WO_ACCTS 0 JP_WO_EXC_NULL_ARSDT 0 JP_WO_INC_NULL_ARSDT 0 NON_DD_CUSTS 2045 NON_DD_CUSTS_MAR 2034 REWRITE_TABLE 0 SC_ACCESS_CNTL 10550 SC_APP_SERVICE 679 SC_APP_SERVICE_L 679 SC_USER 2044 SC_USER_CHAR 1 SC_USER_GROUP 36 SC_USER_GROUP_L 35 SC_USR_GRP_PROF 4432 SC_USR_GRP_USR 8498 TMP_DOCUMAKER_BILL_REGRESSION 118 TMP_DOCUMAKER_REGRESSION 13 TMP_GS 294085 TMP_GS1 1 TMP_STATEMENT_TD 48225 TM_BSEG_SQ_FIX 2233964 TM_BSEG_SQ_OLD 4904484 TM_FIX_SA_NBB 66933 TM_SCHED_PAY_MAR_03 9059 UN_BAL_ACCT 13273 UN_BAL_ACCT_CRM 13273 XX_ACCT_BILL_CYC 5193 XX_NBB_SCHED 85367 XX_NBB_SCHED_251115_05 78201 XX_NBB_SCHED_251115_15 53697 XX_NBB_SCHED_261115 78201 XX_NBB_SCHED_261115_15 53697 XX_NB_SCHED_PAY 1028537 XX_NB_SCHED_PAY_K 1029400 1604 rows selected. SQL> l 1* select TABLE_NAME,NUM_ROWS from user_tables order by TABLE_NAME SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> select instance_name form v$instance; select instance_name form v$instance * ERROR at line 1: ORA-00923: FROM keyword not found where expected SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> select instance_name from v$instance; INSTANCE_NAME ---------------- SIT3 SQL> SQL> SQL> SQL> SQL> SQL> desc mdmadm.D1_CONS_EXT_TYPE Name Null? Type ----------------------------------------- -------- ---------------------------- CONS_EXT_TYPE_CD NOT NULL VARCHAR2(30) BUS_OBJ_CD NOT NULL CHAR(30) D1_CONS_EXT_TYPE_STAT_FLG NOT NULL CHAR(4) D1_UOM_CD VARCHAR2(30) D1_TOU_MAP_ID CHAR(12) SEC_PER_INTRVL NUMBER(5) EXT_THROUGH_DTTM DATE EXT_CUTOFF_TM NOT NULL DATE D1_CONS_EXT_TYPE_FREQ_FLG CHAR(4) INITIAL_LOAD_BATCH_CTRL_CD NOT NULL CHAR(8) HIST_CORR_BATCH_CTRL_CD NOT NULL CHAR(8) REQ_TYPE_CD VARCHAR2(30) SUBSCRIPTION_TYPE_FLG NOT NULL CHAR(4) VERSION NOT NULL NUMBER(5) BO_DATA_AREA CLOB TOU_MAP_TMPLT_CD VARCHAR2(30) D1_CONS_RET_METHOD_FLG NOT NULL CHAR(4) D1_MULT_COND_RES_MODE_FLG CHAR(4) MSRMT_COND_FLG CHAR(6) SQL> select count(*) from mdmadm.D1_CONS_EXT_TYPE; COUNT(*) ---------- 0 SQL> set lines 260 pages 99 SQL> SQL> col Table_Name format a18 SQL> col Index_Name format a18 SQL> col Col_Name format a35 SQL> SQL> break on table_name skip 1 SQL> SQL> select c.instance_name, 2 a.TABLE_NAME "Table_Name", 3 a.INDEX_NAME "Index_Name", 4 a.COLUMN_NAME "Col_Name", 5 a.COLUMN_POSITION "Col_Position", 6 to_char(b.created, 'DD-MON-YYYY HH24:MI') "Created_Date", 7 b.object_type "Object_type" 8 from dba_ind_columns a, dba_objects b, v$instance c 9 where a.TABLE_OWNER='MDMADM' 10 and a.TABLE_NAME in ('D1_CONS_EXT_TYPE') 11 and a.index_name=b.object_name 12 order by a.table_name,a.index_name,a.column_position 13 / INSTANCE_NAME Table_Name Index_Name Col_Name Col_Position Created_Date Object_type ---------------- ------------------ ------------------ ----------------------------------- ------------ -------------------------- ------------------- SIT3 D1_CONS_EXT_TYPE D1C410P0 CONS_EXT_TYPE_CD 1 08-MAR-2018 14:41 INDEX SIT3 D1C410S0 INITIAL_LOAD_BATCH_CTRL_CD 1 08-MAR-2018 14:41 INDEX SIT3 D1C410S1 HIST_CORR_BATCH_CTRL_CD 1 08-MAR-2018 14:41 INDEX SQL> SQL> desc dba_indexes Name Null? Type ----------------------------------------------------------------------------------------------------------------------------------------------------- -------- ---------------------------------------------------------------------------------------------------- OWNER NOT NULL VARCHAR2(30) INDEX_NAME NOT NULL VARCHAR2(30) INDEX_TYPE VARCHAR2(27) TABLE_OWNER NOT NULL VARCHAR2(30) TABLE_NAME NOT NULL VARCHAR2(30) TABLE_TYPE VARCHAR2(11) UNIQUENESS VARCHAR2(9) COMPRESSION VARCHAR2(8) PREFIX_LENGTH NUMBER TABLESPACE_NAME VARCHAR2(30) INI_TRANS NUMBER MAX_TRANS NUMBER INITIAL_EXTENT NUMBER NEXT_EXTENT NUMBER MIN_EXTENTS NUMBER MAX_EXTENTS NUMBER PCT_INCREASE NUMBER PCT_THRESHOLD NUMBER INCLUDE_COLUMN NUMBER FREELISTS NUMBER FREELIST_GROUPS NUMBER PCT_FREE NUMBER LOGGING VARCHAR2(3) BLEVEL NUMBER LEAF_BLOCKS NUMBER DISTINCT_KEYS NUMBER AVG_LEAF_BLOCKS_PER_KEY NUMBER AVG_DATA_BLOCKS_PER_KEY NUMBER CLUSTERING_FACTOR NUMBER STATUS VARCHAR2(8) NUM_ROWS NUMBER SAMPLE_SIZE NUMBER LAST_ANALYZED DATE DEGREE VARCHAR2(40) INSTANCES VARCHAR2(40) PARTITIONED VARCHAR2(3) TEMPORARY VARCHAR2(1) GENERATED VARCHAR2(1) SECONDARY VARCHAR2(1) BUFFER_POOL VARCHAR2(7) FLASH_CACHE VARCHAR2(7) CELL_FLASH_CACHE VARCHAR2(7) USER_STATS VARCHAR2(3) DURATION VARCHAR2(15) PCT_DIRECT_ACCESS NUMBER ITYP_OWNER VARCHAR2(30) ITYP_NAME VARCHAR2(30) PARAMETERS VARCHAR2(1000) GLOBAL_STATS VARCHAR2(3) DOMIDX_STATUS VARCHAR2(12) DOMIDX_OPSTATUS VARCHAR2(6) FUNCIDX_STATUS VARCHAR2(8) JOIN_INDEX VARCHAR2(3) IOT_REDUNDANT_PKEY_ELIM VARCHAR2(3) DROPPED VARCHAR2(3) VISIBILITY VARCHAR2(9) DOMIDX_MANAGEMENT VARCHAR2(14) SEGMENT_CREATED VARCHAR2(3) SQL> set lines 99 SQL> desc dba_indexes ; Name Null? Type ---------------------------------------------------- -------- ------------------------------------ OWNER NOT NULL VARCHAR2(30) INDEX_NAME NOT NULL VARCHAR2(30) INDEX_TYPE VARCHAR2(27) TABLE_OWNER NOT NULL VARCHAR2(30) TABLE_NAME NOT NULL VARCHAR2(30) TABLE_TYPE VARCHAR2(11) UNIQUENESS VARCHAR2(9) COMPRESSION VARCHAR2(8) PREFIX_LENGTH NUMBER TABLESPACE_NAME VARCHAR2(30) INI_TRANS NUMBER MAX_TRANS NUMBER INITIAL_EXTENT NUMBER NEXT_EXTENT NUMBER MIN_EXTENTS NUMBER MAX_EXTENTS NUMBER PCT_INCREASE NUMBER PCT_THRESHOLD NUMBER INCLUDE_COLUMN NUMBER FREELISTS NUMBER FREELIST_GROUPS NUMBER PCT_FREE NUMBER LOGGING VARCHAR2(3) BLEVEL NUMBER LEAF_BLOCKS NUMBER DISTINCT_KEYS NUMBER AVG_LEAF_BLOCKS_PER_KEY NUMBER AVG_DATA_BLOCKS_PER_KEY NUMBER CLUSTERING_FACTOR NUMBER STATUS VARCHAR2(8) NUM_ROWS NUMBER SAMPLE_SIZE NUMBER LAST_ANALYZED DATE DEGREE VARCHAR2(40) INSTANCES VARCHAR2(40) PARTITIONED VARCHAR2(3) TEMPORARY VARCHAR2(1) GENERATED VARCHAR2(1) SECONDARY VARCHAR2(1) BUFFER_POOL VARCHAR2(7) FLASH_CACHE VARCHAR2(7) CELL_FLASH_CACHE VARCHAR2(7) USER_STATS VARCHAR2(3) DURATION VARCHAR2(15) PCT_DIRECT_ACCESS NUMBER ITYP_OWNER VARCHAR2(30) ITYP_NAME VARCHAR2(30) PARAMETERS VARCHAR2(1000) GLOBAL_STATS VARCHAR2(3) DOMIDX_STATUS VARCHAR2(12) DOMIDX_OPSTATUS VARCHAR2(6) FUNCIDX_STATUS VARCHAR2(8) JOIN_INDEX VARCHAR2(3) IOT_REDUNDANT_PKEY_ELIM VARCHAR2(3) DROPPED VARCHAR2(3) VISIBILITY VARCHAR2(9) DOMIDX_MANAGEMENT VARCHAR2(14) SEGMENT_CREATED VARCHAR2(3) SQL> desc dba_constraints Name Null? Type ---------------------------------------------------- -------- ------------------------------------ OWNER VARCHAR2(120) CONSTRAINT_NAME NOT NULL VARCHAR2(30) CONSTRAINT_TYPE VARCHAR2(1) TABLE_NAME NOT NULL VARCHAR2(30) SEARCH_CONDITION LONG R_OWNER VARCHAR2(120) R_CONSTRAINT_NAME VARCHAR2(30) DELETE_RULE VARCHAR2(9) STATUS VARCHAR2(8) DEFERRABLE VARCHAR2(14) DEFERRED VARCHAR2(9) VALIDATED VARCHAR2(13) GENERATED VARCHAR2(14) BAD VARCHAR2(3) RELY VARCHAR2(4) LAST_CHANGE DATE INDEX_OWNER VARCHAR2(30) INDEX_NAME VARCHAR2(30) INVALID VARCHAR2(7) VIEW_RELATED VARCHAR2(14) SQL> select * from dba_constraints where CONSTRAINT_NAME='D1C410P0'; no rows selected SQL> desc dba_indexes Name Null? Type ---------------------------------------------------- -------- ------------------------------------ OWNER NOT NULL VARCHAR2(30) INDEX_NAME NOT NULL VARCHAR2(30) INDEX_TYPE VARCHAR2(27) TABLE_OWNER NOT NULL VARCHAR2(30) TABLE_NAME NOT NULL VARCHAR2(30) TABLE_TYPE VARCHAR2(11) UNIQUENESS VARCHAR2(9) COMPRESSION VARCHAR2(8) PREFIX_LENGTH NUMBER TABLESPACE_NAME VARCHAR2(30) INI_TRANS NUMBER MAX_TRANS NUMBER INITIAL_EXTENT NUMBER NEXT_EXTENT NUMBER MIN_EXTENTS NUMBER MAX_EXTENTS NUMBER PCT_INCREASE NUMBER PCT_THRESHOLD NUMBER INCLUDE_COLUMN NUMBER FREELISTS NUMBER FREELIST_GROUPS NUMBER PCT_FREE NUMBER LOGGING VARCHAR2(3) BLEVEL NUMBER LEAF_BLOCKS NUMBER DISTINCT_KEYS NUMBER AVG_LEAF_BLOCKS_PER_KEY NUMBER AVG_DATA_BLOCKS_PER_KEY NUMBER CLUSTERING_FACTOR NUMBER STATUS VARCHAR2(8) NUM_ROWS NUMBER SAMPLE_SIZE NUMBER LAST_ANALYZED DATE DEGREE VARCHAR2(40) INSTANCES VARCHAR2(40) PARTITIONED VARCHAR2(3) TEMPORARY VARCHAR2(1) GENERATED VARCHAR2(1) SECONDARY VARCHAR2(1) BUFFER_POOL VARCHAR2(7) FLASH_CACHE VARCHAR2(7) CELL_FLASH_CACHE VARCHAR2(7) USER_STATS VARCHAR2(3) DURATION VARCHAR2(15) PCT_DIRECT_ACCESS NUMBER ITYP_OWNER VARCHAR2(30) ITYP_NAME VARCHAR2(30) PARAMETERS VARCHAR2(1000) GLOBAL_STATS VARCHAR2(3) DOMIDX_STATUS VARCHAR2(12) DOMIDX_OPSTATUS VARCHAR2(6) FUNCIDX_STATUS VARCHAR2(8) JOIN_INDEX VARCHAR2(3) IOT_REDUNDANT_PKEY_ELIM VARCHAR2(3) DROPPED VARCHAR2(3) VISIBILITY VARCHAR2(9) DOMIDX_MANAGEMENT VARCHAR2(14) SEGMENT_CREATED VARCHAR2(3) SQL> select * from dba_indexes where index_name='D1C410P0'; OWNER INDEX_NAME INDEX_TYPE ------------------------------ ------------------ --------------------------- TABLE_OWNER TABLE_NAME TABLE_TYPE UNIQUENES COMPRESS PREFIX_LENGTH ------------------------------ ------------------ ----------- --------- -------- ------------- TABLESPACE_NAME INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS ------------------------------ ---------- ---------- -------------- ----------- ----------- MAX_EXTENTS PCT_INCREASE PCT_THRESHOLD INCLUDE_COLUMN FREELISTS FREELIST_GROUPS PCT_FREE LOG ----------- ------------ ------------- -------------- ---------- --------------- ---------- --- BLEVEL LEAF_BLOCKS DISTINCT_KEYS AVG_LEAF_BLOCKS_PER_KEY AVG_DATA_BLOCKS_PER_KEY ---------- ----------- ------------- ----------------------- ----------------------- CLUSTERING_FACTOR STATUS NUM_ROWS SAMPLE_SIZE LAST_ANAL ----------------- -------- ---------- ----------- --------- DEGREE INSTANCES PAR T G S BUFFER_ ---------------------------------------- ---------------------------------------- --- - - - ------- FLASH_C CELL_FL USE DURATION PCT_DIRECT_ACCESS ITYP_OWNER ------- ------- --- --------------- ----------------- ------------------------------ ITYP_NAME ------------------------------ PARAMETERS --------------------------------------------------------------------------------------------------- GLO DOMIDX_STATU DOMIDX FUNCIDX_ JOI IOT DRO VISIBILIT DOMIDX_MANAGEM SEG --- ------------ ------ -------- --- --- --- --------- -------------- --- MDMADM D1C410P0 NORMAL MDMADM D1_CONS_EXT_TYPE TABLE UNIQUE DISABLED MDMIS_01 2 255 10 YES 0 0 0 0 0 0 VALID 0 0 08-MAR-18 1 1 NO N N N DEFAULT DEFAULT DEFAULT NO YES NO NO NO VISIBLE NO SQL> desc dba_indexes Name Null? Type ---------------------------------------------------- -------- ------------------------------------ OWNER NOT NULL VARCHAR2(30) INDEX_NAME NOT NULL VARCHAR2(30) INDEX_TYPE VARCHAR2(27) TABLE_OWNER NOT NULL VARCHAR2(30) TABLE_NAME NOT NULL VARCHAR2(30) TABLE_TYPE VARCHAR2(11) UNIQUENESS VARCHAR2(9) COMPRESSION VARCHAR2(8) PREFIX_LENGTH NUMBER TABLESPACE_NAME VARCHAR2(30) INI_TRANS NUMBER MAX_TRANS NUMBER INITIAL_EXTENT NUMBER NEXT_EXTENT NUMBER MIN_EXTENTS NUMBER MAX_EXTENTS NUMBER PCT_INCREASE NUMBER PCT_THRESHOLD NUMBER INCLUDE_COLUMN NUMBER FREELISTS NUMBER FREELIST_GROUPS NUMBER PCT_FREE NUMBER LOGGING VARCHAR2(3) BLEVEL NUMBER LEAF_BLOCKS NUMBER DISTINCT_KEYS NUMBER AVG_LEAF_BLOCKS_PER_KEY NUMBER AVG_DATA_BLOCKS_PER_KEY NUMBER CLUSTERING_FACTOR NUMBER STATUS VARCHAR2(8) NUM_ROWS NUMBER SAMPLE_SIZE NUMBER LAST_ANALYZED DATE DEGREE VARCHAR2(40) INSTANCES VARCHAR2(40) PARTITIONED VARCHAR2(3) TEMPORARY VARCHAR2(1) GENERATED VARCHAR2(1) SECONDARY VARCHAR2(1) BUFFER_POOL VARCHAR2(7) FLASH_CACHE VARCHAR2(7) CELL_FLASH_CACHE VARCHAR2(7) USER_STATS VARCHAR2(3) DURATION VARCHAR2(15) PCT_DIRECT_ACCESS NUMBER ITYP_OWNER VARCHAR2(30) ITYP_NAME VARCHAR2(30) PARAMETERS VARCHAR2(1000) GLOBAL_STATS VARCHAR2(3) DOMIDX_STATUS VARCHAR2(12) DOMIDX_OPSTATUS VARCHAR2(6) FUNCIDX_STATUS VARCHAR2(8) JOIN_INDEX VARCHAR2(3) IOT_REDUNDANT_PKEY_ELIM VARCHAR2(3) DROPPED VARCHAR2(3) VISIBILITY VARCHAR2(9) DOMIDX_MANAGEMENT VARCHAR2(14) SEGMENT_CREATED VARCHAR2(3) SQL> select OWNER,INDEX_NAME,INDEX_TYPE,TABLE_NAME,UNIQUENESS,STATUS from dba_indexes where INDEX_NAME='D1C410P0'; OWNER INDEX_NAME INDEX_TYPE TABLE_NAME ------------------------------ ------------------ --------------------------- ------------------ UNIQUENES STATUS --------- -------- MDMADM D1C410P0 NORMAL D1_CONS_EXT_TYPE UNIQUE VALID SQL> set lines 999 SQL> / OWNER INDEX_NAME INDEX_TYPE TABLE_NAME UNIQUENES STATUS ------------------------------ ------------------ --------------------------- ------------------ --------- -------- MDMADM D1C410P0 NORMAL D1_CONS_EXT_TYPE UNIQUE VALID SQL> select count(*) from MDMADM.D1_CONS_EXT_TYPE; COUNT(*) ---------- 0 SQL> SQL> SQL> SQL> SQL> set timing on SQL> set trimspool off SQL> set linesize 32000 SQL> set long 20000000 SQL> set pagesize 0 SQL> column ddl format a50000 SQL> set longchunksize 20000000 SQL> select dbms_metadata.get_ddl('INDEX','D1_CONS_EXT_TYPE','MDMADM') from dual 2 / ERROR: ORA-31603: object "D1_CONS_EXT_TYPE" of type INDEX not found in schema "MDMADM" ORA-06512: at "SYS.DBMS_METADATA", line 5805 ORA-06512: at "SYS.DBMS_METADATA", line 8344 ORA-06512: at line 1 no rows selected Elapsed: 00:00:00.67 SQL> SQL> SQL> D1_CONS_EXT_TYPE SP2-0734: unknown command beginning "D1_CONS_EX..." - rest of line ignored. SQL> SQL> SQL> SQL> SQL> SQL> set lines 260 pages 99 SQL> SQL> col Table_Name format a18 SQL> col Index_Name format a18 SQL> col Col_Name format a35 SQL> SQL> break on table_name skip 1 SQL> SQL> select c.instance_name, 2 a.TABLE_NAME "Table_Name", 3 a.INDEX_NAME "Index_Name", 4 a.COLUMN_NAME "Col_Name", 5 a.COLUMN_POSITION "Col_Position", 6 to_char(b.created, 'DD-MON-YYYY HH24:MI') "Created_Date", 7 b.object_type "Object_type" 8 from dba_ind_columns a, dba_objects b, v$instance c 9 where a.TABLE_OWNER='MDMADM' 10 and a.TABLE_NAME in ('D1C410P0') 11 and a.index_name=b.object_name 12 order by a.table_name,a.index_name,a.column_position 13 / no rows selected Elapsed: 00:00:00.07 SQL> SQL> SQL> SQL> SQL> set timing on SQL> set trimspool off SQL> set linesize 32000 SQL> set long 20000000 SQL> set pagesize 0 SQL> column ddl format a50000 SQL> set longchunksize 20000000 SQL> select dbms_metadata.get_ddl('INDEX','D1C410P0','MDMADM') from dual 2 / CREATE UNIQUE INDEX "MDMADM"."D1C410P0" ON "MDMADM"."D1_CONS_EXT_TYPE" ("CONS_EXT_TYPE_CD") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS TABLESPACE "MDMIS_01" Elapsed: 00:00:00.24 SQL> SQL> SQL> SQL> ! SQL>