OSS_COPY_MAP_OBJ_METADATA
This table stores the transformed view object specific copy map metadata at run time.
Details
-
Schema: FUSION
-
Object owner: OSS
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
OSS_COPY_MAP_OBJ_METADATA_PK |
OBJECT_METADATA_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| OBJECT_METADATA_ID | NUMBER | 18 | Yes | System generated unique identifier to store the metadata id of the object. | |
| MAPPING_NAME | VARCHAR2 | 1000 | Yes | Identifies the name of copy map of the metadata row. | |
| TARGET_VO | VARCHAR2 | 4000 | Full qualified view object name of the target view object. | ||
| TARGET_TABLE | VARCHAR2 | 300 | Identifies the name of the target table. | ||
| SOURCE_VO | VARCHAR2 | 4000 | Full qualified view object name of the source view object. | ||
| SOURCE_TABLE | VARCHAR2 | 300 | Identifies the name of the source table. | ||
| OBJECT_NAME | VARCHAR2 | 300 | Identifies the source object name in the corresponding copy map row. | ||
| PRIMARY_KEY_ATTRIBUTE | VARCHAR2 | 500 | Identifies the primary key attribute of the source view object. | ||
| PRIMARY_KEY_COLUMN | VARCHAR2 | 500 | Identifies the primary key column of the source table. | ||
| QUERY_TYPE | NUMBER | 1 | Identifies the query type for the metadata row. 1 - If using query attribute. ; 2 - If using Join view object , 3 - If blind query. | ||
| QUERY_COLUMN | VARCHAR2 | 500 | Identifies the query column within the source table. | ||
| JOIN_TABLE | VARCHAR2 | 300 | Identifies the table name to be used for join, if the query type is 2. Stores null for other query types. | ||
| JOIN_COLUMN | VARCHAR2 | 300 | Identifies the column name to be used for join, if the query type is 2. Stores null for other query types. | ||
| IN_MEMORY_FILTER | VARCHAR2 | 4000 | Identifies the SQL equivalent corresponding to the in memory filter for the copy map view object row, if any. | ||
| ORDER_OF_EXECUTION | NUMBER | 2 | Identifies the order of execution. | ||
| SELECT_QUERY_TEXT | CLOB | Identifies the final SQL to be used to select the records which would be later inserted to oss_batch_items table. | |||
| COPY_MAP_BATCH_ID | NUMBER | 18 | Yes | Identifies the user specific session identifier for a specific copy map action. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| OSS_COPY_MAP_OBJ_METADATA_N1 | Non Unique | Default | COPY_MAP_BATCH_ID |
| OSS_COPY_MAP_OBJ_METADATA_N2 | Non Unique | Default | OBJECT_NAME, COPY_MAP_BATCH_ID |
| OSS_COPY_MAP_OBJ_METADATA_PK | Unique | Default | OBJECT_METADATA_ID |