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. |