Tuesday, July 22, 2014

ODI 12c 12.1.3 Repository Tables : Master 67 tables & Work 153 tables total 220 tables.


Master repository Tables:  67

TNAME                          TABTYP
------------------------------ ------
SNP_ACTION                     TABLE
SNP_AGENT                      TABLE
SNP_AGENT_PROP                 TABLE
SNP_AGENT_PROP_LST             TABLE
SNP_ALLOC_AGENT                TABLE
SNP_CONNECT                    TABLE
SNP_CONNECT_PROP               TABLE
SNP_CONTEXT                    TABLE
SNP_CONV_DT                    TABLE
SNP_DATA                       TABLE
SNP_DATASOURCE                 TABLE
SNP_DT                         TABLE
SNP_ENTITY                     TABLE
SNP_ENT_ID                     TABLE
SNP_ENT_PRINCIPAL              TABLE
SNP_ESS                        TABLE
SNP_FF_VALUEM                  TABLE
SNP_FIELD                      TABLE
SNP_FIELD_LOOKUP               TABLE
SNP_FLEX_FIELD                 TABLE
SNP_GRP_ACTION                 TABLE
SNP_HIST_VERSION               TABLE
SNP_HOST                       TABLE
SNP_HOST_MOD                   TABLE
SNP_INDEX_TYPE                 TABLE
SNP_INST_OBJ                   TABLE
SNP_LAGENT                     TABLE
SNP_LANG                       TABLE
SNP_LANG_ELT                   TABLE
SNP_LANG_TECHNO                TABLE
SNP_LB_AGENT                   TABLE
SNP_LE_TECHNO                  TABLE
SNP_LICENSE                    TABLE
SNP_LINE_ACTION                TABLE
SNP_LINK                       TABLE
SNP_LOC_REP                    TABLE
SNP_LOOKUP                     TABLE
SNP_LOOKUP_VALUE               TABLE
SNP_LSCHEMA                    TABLE
SNP_METHOD                     TABLE
SNP_MODULE                     TABLE
SNP_MORIG_TXT                  TABLE
SNP_MTXT                       TABLE
SNP_MTXT_PART                  TABLE
SNP_M_IMPORT_REP               TABLE
SNP_OBJECT                     TABLE
SNP_OPEN_TOOL                  TABLE
SNP_PROFILE                    TABLE
SNP_PROF_METH                  TABLE
SNP_PSCHEMA                    TABLE
SNP_PSCHEMA_CONT               TABLE
SNP_PWD_POLICY                 TABLE
SNP_PWD_RULE                   TABLE
SNP_REM_REP                    TABLE
SNP_ROLE_ENT_PRP               TABLE
SNP_SOLUTION                   TABLE
SNP_SOL_ELT                    TABLE
SNP_SUB_LANG                   TABLE
SNP_TECHNO                     TABLE
SNP_USER                       TABLE
SNP_USER_METH                  TABLE
SNP_USER_OBJ_METH              TABLE
SNP_USER_PREF                  TABLE
SNP_USER_PROF                  TABLE
SNP_USR_PREFERENCE             TABLE
SNP_U_O_M_REP                  TABLE
SNP_VERSION                    TABLE

67 rows selected.

Work Repository Tables:  153..

TNAME                          TABTYPE  CLUSTERID
------------------------------ ------- ----------
SNP_CEC_LP                     TABLE
SNP_CEC_SCEN                   TABLE
SNP_COL                        TABLE
SNP_COND                       TABLE
SNP_DATA_SET                   TABLE
SNP_DEPLOY_SPEC                TABLE
SNP_DIAGRAM                    TABLE
SNP_DIAG_PARAM                 TABLE
SNP_DT_BRP                     TABLE
SNP_EXEC_UNIT                  TABLE
SNP_EXEC_UNIT_GRP              TABLE
SNP_EXP_TXT                    TABLE
SNP_EXP_TXT_HEADER             TABLE
SNP_FF_VALUEE                  TABLE
SNP_FF_VALUEW                  TABLE
SNP_FOLDER                     TABLE
SNP_GRP_STATE                  TABLE
SNP_ID                         TABLE
SNP_IMPORT_REP                 TABLE
SNP_INDIRECT_MREF              TABLE
SNP_JOIN                       TABLE
SNP_JOIN_COL                   TABLE
SNP_KEY                        TABLE
SNP_KEY_COL                    TABLE
SNP_LINE_TRT                   TABLE
SNP_LINE_TRT_UE                TABLE
SNP_LINK_COORD                 TABLE
SNP_LINK_DIAG                  TABLE
SNP_LOAD_PLAN                  TABLE
SNP_LOCK                       TABLE
SNP_LOCKED_OBJECT              TABLE
SNP_LOC_REPW                   TABLE
SNP_LPI_EC_VAR_LOG             TABLE
SNP_LPI_EXC_LOG                TABLE
SNP_LPI_RUN                    TABLE
SNP_LPI_STEP                   TABLE
SNP_LPI_STEP_LOG               TABLE
SNP_LPI_STEP_VAR               TABLE
SNP_LPI_TXT_LOG                TABLE
SNP_LPI_VAR                    TABLE
SNP_LPI_VAR_LOG                TABLE
SNP_LP_INST                    TABLE
SNP_LP_STEP                    TABLE
SNP_LP_STEP_VAR                TABLE
SNP_LP_VAR                     TABLE
SNP_MAPPING                    TABLE
SNP_MAP_ATTR                   TABLE
SNP_MAP_ATTR_INFO              TABLE
SNP_MAP_COMP                   TABLE
SNP_MAP_COMP_TYPE              TABLE
SNP_MAP_CONN                   TABLE
SNP_MAP_CP                     TABLE
SNP_MAP_CP_ROLE                TABLE
SNP_MAP_DATA_TYPE              TABLE
SNP_MAP_EXPR                   TABLE
SNP_MAP_EXPR_REF               TABLE
SNP_MAP_PROP                   TABLE
SNP_MAP_PROP_DEF               TABLE
SNP_MAP_REF                    TABLE
SNP_MAP_REF_PP                 TABLE
SNP_MC_CONSTRAINT              TABLE
SNP_MISSING_REF                TABLE
SNP_MODEL                      TABLE
SNP_MODEL_EXTRACT              TABLE
SNP_MODEL_REPLICAT             TABLE
SNP_MOD_FOLDER                 TABLE
SNP_OBJECT_ID                  TABLE
SNP_OBJECT_ID_COL              TABLE
SNP_OBJ_DIAG                   TABLE
SNP_OBJ_STATE                  TABLE
SNP_OBJ_TRACE                  TABLE
SNP_ORIG_TXT                   TABLE
SNP_PACKAGE                    TABLE
SNP_PARAM_LPI_RUN              TABLE
SNP_PARAM_SESS                 TABLE
SNP_PARTITION                  TABLE
SNP_PHY_EXPR                   TABLE
SNP_PHY_NODE                   TABLE
SNP_PLAN_AGENT                 TABLE
SNP_POP                        TABLE
SNP_POP_CLAUSE                 TABLE
SNP_POP_COL                    TABLE
SNP_POP_CONSTRAINT             TABLE
SNP_POP_CONTEXT                TABLE
SNP_POP_MAPPING                TABLE
SNP_PROJECT                    TABLE
SNP_REV_COL                    TABLE
SNP_REV_COL_FFV                TABLE
SNP_REV_COND                   TABLE
SNP_REV_COND_FFV               TABLE
SNP_REV_FOR_TABLE              TABLE
SNP_REV_JOIN                   TABLE
SNP_REV_JOIN_COL               TABLE
SNP_REV_JOIN_FFV               TABLE
SNP_REV_KEY                    TABLE
SNP_REV_KEY_COL                TABLE
SNP_REV_KEY_FFV                TABLE
SNP_REV_MODEL_FFV              TABLE
SNP_REV_PARTITION              TABLE
SNP_REV_SUB_MODEL              TABLE
SNP_REV_TABLE                  TABLE
SNP_REV_TABLE_FFV              TABLE
SNP_RT_BRP                     TABLE
SNP_SB                         TABLE
SNP_SB_STEP                    TABLE
SNP_SB_TASK                    TABLE
SNP_SCEN                       TABLE
SNP_SCEN_BRP                   TABLE
SNP_SCEN_FOLDER                TABLE
SNP_SCEN_REPORT                TABLE
SNP_SCEN_STEP                  TABLE
SNP_SCEN_TASK                  TABLE
SNP_SCEN_TXT                   TABLE
SNP_SEQUENCE                   TABLE
SNP_SEQ_DATA                   TABLE
SNP_SEQ_SB                     TABLE
SNP_SEQ_SCEN                   TABLE
SNP_SEQ_SESS                   TABLE
SNP_SESSION                    TABLE
SNP_SESSION_DBG                TABLE
SNP_SESS_FOLDER                TABLE
SNP_SESS_STEP                  TABLE
SNP_SESS_STEP_LV               TABLE
SNP_SESS_TASK                  TABLE
SNP_SESS_TASK_LOG              TABLE
SNP_SESS_TASK_LS               TABLE
SNP_SESS_TXT_LOG               TABLE
SNP_SOURCE_TAB                 TABLE
SNP_SRC_SET                    TABLE
SNP_STATE                      TABLE
SNP_STATE2                     TABLE
SNP_STEP                       TABLE
SNP_STEP_LOG                   TABLE
SNP_STEP_REPORT                TABLE
SNP_SUB_MODEL                  TABLE
SNP_TABLE                      TABLE
SNP_TASK_TXT                   TABLE
SNP_TRT                        TABLE
SNP_TXT                        TABLE
SNP_TXT_CROSSR                 TABLE
SNP_TXT_HEADER                 TABLE
SNP_UE_ORIG                    TABLE
SNP_UE_USED                    TABLE
SNP_UFUNC                      TABLE
SNP_UFUNC_IMPL                 TABLE
SNP_UFUNC_TECHNO               TABLE
SNP_USER_EXIT                  TABLE
SNP_VAR                        TABLE
SNP_VAR_DATA                   TABLE
SNP_VAR_PLAN_AGENT             TABLE
SNP_VAR_SB                     TABLE
SNP_VAR_SCEN                   TABLE
SNP_VAR_SESS                   TABLE

153 rows selected.

No comments:

Post a Comment