Table Detail Report

DM_USER_IND_COLUMNS



Column Section Top of Page


Table-level Detail

Description: Contains informaton from USER_INDEXES and USER_IND_COLUMNS.
Definition: Contains information from USER_INDEXES and USER_IND_COLUMNS -- used in schema refresh tools
Table Type: ACTIVITY





Column Detail - DM_USER_IND_COLUMNS


Column Name Type Null? Definition
COLUMN_NAME VARCHAR(30) N column name for an index
COLUMN_POSITION DOUBLE N column position
INDEX_NAME VARCHAR(30) N index name
TABLESPACE_NAME VARCHAR(30) N tablespace name for the index
TABLE_NAME VARCHAR(30) N TABLE NAME
TABLE_OWNER VARCHAR(30) N table owner
UNIQUENESS VARCHAR(9) Y defines whether the index is unique


DM_USER_TAB_COLS



Column Section Top of Page


Table-level Detail

Description: Contains the same information as USER_TAB_COLUMNS
Definition: Contains the same information as USER_TAB_COLUMNS -- used by schema refresh tools
Table Type: ACTIVITY





Column Detail - DM_USER_TAB_COLS


Column Name Type Null? Definition
COLUMN_ID DOUBLE N column_id for the column
COLUMN_NAME VARCHAR(30) Y column name for the column
DATA_DEFAULT VARCHAR(255) Y data default
DATA_LENGTH DOUBLE Y data length of the column
DATA_TYPE VARCHAR(9) Y data type of the column
NULLABLE VARCHAR(1) Y NULLABLE property of the column
TABLESPACE_NAME VARCHAR(30) Y tablespace name for the table
TABLE_NAME VARCHAR(30) Y TABLE NAME


DM_VDATA_EXCLUDE_DTL



Column Section Relationship Section Top of Page


Table-level Detail

Description: DM_VDATA_EXCLUDE_DTL
Definition: Store reasons a table cannot be compared by a data compare process between 2 databases
Table Type: ACTIVITY





Column Detail - DM_VDATA_EXCLUDE_DTL


Column Name Type Null? Definition
DM_VDATA_EXCLUDE_DTL_ID DOUBLE N PRIMARY KEY
DM_VDATA_MASTER_ID DOUBLE N FK to DM_VDATA_MASTER
EXCLUDE_REASON_FLAG DOUBLE N Reasons a table is excluded from the compare process. 10= 'Table does not have a single, numeric, uniquely indexed column'. 20 = 'Table has an unsupported data type.' 30 = 'Table marked for downtime Migration'.
EXCLUDE_REASON_TXT VARCHAR(1000) Y Text will contain the description as specified above.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - DM_VDATA_EXCLUDE_DTL


Child Column in DM_VDATA_EXCLUDE_DTL(FK) Parent Table Name Parent Column Name
Parents: DM_VDATA_MASTER_ID DM_VDATA_MASTER DM_VDATA_MASTER_ID


DM_VDATA_MASTER



Column Section Relationship Section Top of Page


Table-level Detail

Description: DM_VDATA_MASTER
Definition: Store data about data compare process between 2 databases
Table Type: ACTIVITY





Column Detail - DM_VDATA_MASTER


Column Name Type Null? Definition
APPL_IDENT VARCHAR(100) Y The client application id that compared the table/owner when status = 'EXECUTING'
BEGIN_DT_TM DATETIME Y Date the last compare began
COLUMN_LIST LONGTEXT Y Comma delimited list of column values to be compared for a table.
COMPARE_INDEX_NAME VARCHAR(30) Y The unique index name used to uniquely compare the data.
COMPARE_STATUS VARCHAR(255) N Status description of the last compare
CURR_MISMATCH_ROW_CNT DOUBLE Y The number of rows that mismatched on the current compare execution
DATA_TYPE_LIST VARCHAR(4000) Y Stores the data type list that makes up the uniquely indexed columns
DM_VDATA_MASTER_ID DOUBLE N Primary Key Unique Identifier
END_DT_TM DATETIME Y Date the last compare ended
KEYID_COLUMN_NAME VARCHAR(30) N The single unique indexed column name used during the compare process.
LAG_DT_TM DATETIME Y The max delivery lag at the time the table was compared.
LAST_COMPARE_CNT DOUBLE Y Count of rows last matched
LAST_COMPARE_DT_TM DATETIME Y Last Date/Time the table was compared.
LAST_MATCH_CNT DOUBLE Y Count of rows last matched
LAST_MATCH_DT_TM DATETIME Y Last date/time a table matched
LAST_SRC_MOD_DT_TM DATETIME Y The all_tab_modification.timestamp value at the time of the last compare.
MAX_SRC_KEYID DOUBLE Y The max key value from the Source table.
MESSAGE_TXT VARCHAR(4000) Y Stores informational and/or error messages that occur during compare.
MISMATCH_BEG_KEYID DOUBLE Y The min key value that was mismatched for the current compare range.
MISMATCH_END_KEYID DOUBLE Y The ending key value for the current compare range.
MISMATCH_EVENT_CNT DOUBLE Y Number of times a table has successively mismatched
MISMATCH_ROWID VARCHAR(10) Y The Source's rowid for the mismatched row.
MISMATCH_ROW_DT_TM DATETIME Y This value is returned from the Source table based on some updt_dt_tm (or equivalent) column during the compare process.
MISMATCH_UNIQUE_KEY_TXT VARCHAR(4000) Y the concatenated key for mismatches
MM_PULL_KEY_FROM_SRC_IND DOUBLE Y Indicates whether to pull updt_dt_tm and rowid mismatch values from the source database.
OBJECT_ID_SRC DOUBLE Y The object_id from all_objects for the table from the Source Database.
OWNER_NAME VARCHAR(30) N Table Owner
PREV_MISMATCH_ROW_CNT DOUBLE Y The number of rows that mismatched on the previous compare execution
RANGE_BEG_KEYID DOUBLE Y The beginning key value for the current compare range.
RANGE_END_KEYID DOUBLE Y The ending key value for the current compare range.
RANGE_START_KEYID DOUBLE Y The first key value to begin comparison on (key values previous to this value do not need to be compared).
ROWS_TO_COMPARE DOUBLE Y Number of Rows to Compare each time.
ROW_DT_TM_COL_NAME VARCHAR(30) Y The column name used to retrieve mismatched row's date/time
TABLE_NAME VARCHAR(30) N Table Name
TTL_ROWS_COMPARED DOUBLE Y The total cumulative number of rows compared for a table.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - DM_VDATA_MASTER




Parent Column in DM_VDATA_MASTER (PK) Child Table Name Child Column Name
Children: DM_VDATA_MASTER_ID DM_VDATA_EXCLUDE_DTL DM_VDATA_MASTER_ID


DM_VDATA_MISMATCH



Column Section Top of Page


Table-level Detail

Description: DM_VDATA_MISMATCH
Definition: Store key values for a table that did not match during a compare process.
Table Type: ACTIVITY





Column Detail - DM_VDATA_MISMATCH


Column Name Type Null? Definition
DM_VDATA_MASTER_ID DOUBLE N FK to DM_VDATA_MASTER
DM_VDATA_MISMATCH_ID DOUBLE N PRIMARY KEY
KEYID DOUBLE N Key value for a table mismatch
MISMATCH_ROWID VARCHAR(255) Y The Source's rowid for the mismatched row.
MISMATCH_ROW_DT_TM DATETIME Y This value is returned from the Source table based on some updt_dt_tm (or equivalent) column during the compare process.
MM_ROWID VARCHAR(10) Y The source table rowid for the mismatched row.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.