| Oracle® Warehouse Builder API and Scripting Reference 11g Release 2 (11.2) Part Number E10584-01 |
|
|
PDF · Mobi · ePub |
| Oracle® Warehouse Builder API and Scripting Reference 11g Release 2 (11.2) Part Number E10584-01 |
|
|
PDF · Mobi · ePub |
The Warehouse Builder provides a set of pre-built views for both the design and runtime environments. These views are called the Warehouse Builder public views and are the API alternative to using the Repository Browser described in the Oracle Warehouse Builder Data Modeling, ETL, and Data Quality Guide.
Use these views to access to metadata and data stored in Warehouse Builder repositories.
You can access public views by logging in to SQL*Plus with default workspace@set. When you login to SQL*Plus, you can access public views (design-time public views or runtime public views) from your default workspace.If you try to access public views from any workspace other than the default, then you must call: WB_workspace_management.set_workspace(<wksp_name>, <wksp_owner>). If you want to switch to a workspace other than the default one, then you can call the WB_workspace_management.set_workspace procedure. You must have the ACCESS_PUBLICVIEW_BROWSER system privilege to retrieve useful information from the pubic views. Otherwise, you will get "0 rows returned." You may need to ask the workspace owner or workspace admin to grant the system privilege ACCESS_PUBLICVIEW_BROWSER.
This chapter contains a catalog of the public views for the runtime environment.
The Runtime Repository contains all of the deployment and execution audit data. Use these public views to access this data. These views are used by Runtime Audit Browser to provide audit reporting.
Table 1-1 ALL_RT_AUDIT_LOCATIONS
| Column Name | Data Type | Description |
|---|---|---|
|
LOCATION_AUDIT_ID |
NUMBER (22) |
Internal primary key to audit_location |
|
RUNTIME_VERSION |
VARCHAR2 (64) |
Runtime version number |
|
CLIENT_VERSION |
VARCHAR2 (64) |
Design client version number |
|
CLIENT_REPOSITORY |
VARCHAR2 (30) |
Name of the client repository |
|
CLIENT_REPOSITORY_VERSION |
VARCHAR2 (64) |
Client repository version number |
|
REPOSITORY_USER |
VARCHAR2 (30) |
Username of the design repository |
|
GENERATION_TIME |
DATE |
When the deployment was generated |
|
DEPLOYMENT_AUDIT_ID |
NUMBER (22) |
Internal audit ID of the deployment |
|
DEPLOYMENT_SEQUENCE_NUMBER |
NUMBER (10) |
Sequence number of this location in the deployment |
|
DEPLOYMENT_AUDIT_NAME |
VARCHAR2 (64) |
Audit name of the location |
|
DEPLOYMENT_AUDIT_STATUS |
VARCHAR2 (4000) |
INACTIVE, READY, or COMPLETE |
|
LOCATION_AUDIT_STATUS |
VARCHAR2 (4000) |
INACTIVE, READY, BUSY_PREPARE, BUSY_UNPREPARE, BUSY_DEPLOY, BUSY_UNDO, BUSY_FINALIZE, or COMPLETE |
|
LOCATION_UOID |
VARCHAR2 (32) |
Client UOID of the location |
|
LOCATION_NAME |
VARCHAR2 (64) |
Name of the location |
|
LOCATION_TYPE |
VARCHAR2 (64) |
Type of the location. (ODB, OWF, OEM) |
|
LOCATION_TYPE_VERSION |
VARCHAR2 (64) |
Version of the target |
|
NUMBER_SCRIPT_RUN_ERRORS |
NUMBER (10) |
Number of errors detected |
|
NUMBER_SCRIPT_RUN_WARNINGS |
NUMBER (10) |
Number of warnings detected |
|
CREATED_ON |
DATE |
The time audit data was created |
|
CREATED_BY |
VARCHAR2 (30) |
Database username |
|
UPDATED_ON |
DATE |
The time audit data was updated |
|
UPDATED_BY |
VARCHAR2 (30) |
Database username |
Table 1-2 ALL_RT_AUDIT_LOCATION_MESSAGES
| Column Name | Data Type | Description |
|---|---|---|
|
MESSAGE_AUDIT_ID |
NUMBER (22) |
Internal key to audit_location_message. Primary when used with message_line_number. |
|
LOCATION_AUDIT_ID |
NUMBER (22) |
Internal key to audit_location |
|
MESSAGE_SEVERITY |
VARCHAR2 (4000) |
INFORMATIONAL, WARNING, ERROR, or RECOVERY |
|
MESSAGE_LINE_NUMBER |
NUMBER (10) |
1 for single line messages >0 for multiple line messages (Forms primary key when used with message_audit_id) |
|
MESSAGE_TEXT |
VARCHAR2 (4000) |
plain_text or nls_key |
|
CREATED_ON |
DATE |
The time audit data was created |
|
CREATED_BY |
VARCHAR2 (30) |
Database username |
Table 1-3 ALL_RT_AUDIT_LOCATION_FILES
| Column Name | Data Type | Description |
|---|---|---|
|
FILE_AUDIT_ID |
NUMBER (22) |
Internal primary key to audit_location_file |
|
LOCATION_AUDIT_ID |
NUMBER (22) |
Internal key to audit_location |
|
FILE_TYPE |
VARCHAR2 (64) |
SQLLoaderLogFile, ShellOutputStream, ShellErrorStream, FTPOutputStream, or FTPErrorStream |
|
FILE_TEXT |
CLOB |
Contents of the file |
|
FORMAT |
VARCHAR2(4000) |
TEXT or HTML |
|
CREATED_ON |
DATE |
The time audit data was created |
|
CREATED_BY |
VARCHAR2 (30) |
Database username |
Table 1-4 ALL_RT_AUDIT_OBJECTS
| Column Name | Data Type | Description |
|---|---|---|
|
OBJECT_AUDIT_ID |
NUMBER (22) |
Internal primary key to audit_object |
|
PARENT_OBJECT_AUDIT_ID |
NUMBER (22) |
Internal key to parent audit_script_run |
|
LOCATION_AUDIT_ID |
NUMBER (22) |
Internal key to audit_location |
|
LOCATION_SEQUENCE_NUMBER |
NUMBER (10) |
Sequence number of this object in the location |
|
OBJECT_UOID |
VARCHAR2 (32) |
UOID of the deployed object |
|
OBJECT_NAME |
VARCHAR2 (64) |
Name of the deployed object |
|
OBJECT_TYPE |
VARCHAR2 (64) |
Type of deployed object. (PLSQLMap, Table, Dimension, SQLLoaderControlFile) |
|
CLIENT_VERSION_TAG |
VARCHAR2 (80) |
Client version identifier of this object |
|
NUMBER_SCRIPT_RUN_ERRORS |
NUMBER (10) |
Number of errors detected |
|
NUMBER_SCRIPT_RUN_WARNINGS |
NUMBER (10) |
Number of warnings detected |
|
STATUS_WHEN_DEPLOYED |
VARCHAR2 (4000) |
VALID, INVALID, REMOVED, or UNCERTAIN |
|
CREATED_ON |
DATE |
The time audit data was created |
|
CREATED_BY |
VARCHAR2 (30) |
Database username |
|
UPDATE_ON |
DATE |
The time audit data was updated |
|
UPDATED_BY |
VARCHAR2 (30) |
Database username |
Table 1-5 ALL_RT_AUDIT_SCRIPT_MESSAGES
| Column Name | Data Type | Description |
|---|---|---|
|
MESSAGE_AUDIT_ID |
NUMBER (22) |
Internal primary key to audit_script_file |
|
SCRIPT_RUN_AUDIT_ID |
NUMBER (22) |
Internal key to audit_script_run |
|
MESSAGE_SEVERITY |
VARCHAR2 (4000) |
INFORMATIONAL, WARNING, ERROR, or RECOVERY |
|
MESSAGE_LINE_NUMBER |
NUMBER (10) |
1 for single line messages >0 for multiple line messages (Forms primary key when used with message_audit_id) |
|
MESSAGE_TEXT |
VARCHAR2 (4000) |
plain_text or nls_key |
|
CREATED_ON |
DATE |
The time the audit data was created |
|
CREATED_BY |
VARCHAR2 (30) |
Database username |
Table 1-6 ALL_RT_AUDIT_SCRIPT_RUNS
| Column Name | Data Type | Description |
|---|---|---|
|
SCRIPT_RUN_AUDIT_ID |
NUMBER (22) |
Internal primary key to audit_script_run |
|
LOCATION_AUDIT_ID |
NUMBER (22) |
Internal key to audit_location |
|
OBJECT_AUDIT_ID |
NUMBER (22) |
Internal key to audit_object |
|
SCRIPT_RUN_AUDIT_STATUS |
VARCHAR2 (4000) |
BUSY, COMPLETE, UNCERTAIN, FAILED or INACTIVE |
|
OPERATION |
VARCHAR2 (4000) |
DEPLOY, or UNDO |
|
SCRIPT_ACTION |
VARCHAR2 (4000) |
CREATE, DROP, UPGRADE, or REPORT |
|
SCRIPT |
CLOB |
Script used to perform the action |
|
SCRIPT_FORMAT |
VARCHAR2 (4000) |
TEXT or HTML |
|
SCRIPT_GENERATION_TIME |
DATE |
The time the script was created |
|
NUMBER_SCRIPT_RUN_ERRORS |
NUMBER |
The number of errors detected |
|
NUMBER_SCRIPT_RUN_WARNINGS |
NUMBER |
The number of warnings detected |
|
ELAPSE_TIME |
NUMBER (10) |
The number of seconds that elapsed |
|
CREATED_ON |
DATE |
The time the audit data was created |
|
CREATED_BY |
VARCHAR2 (30) |
Database username |
|
UPDATED_ON |
DATE |
The time the audit data updated |
|
UPDATED_BY |
VARCHAR2 (30) |
Database username |
Table 1-7 ALL_RT_AUDIT_SCRIPT_FILES
| Column Name | Data Type | Description |
|---|---|---|
|
FILE_AUDIT_ID |
NUMBER (22) |
Internal primary key to audit_script_file |
|
SCRIPT_RUN_AUDIT_ID |
NUMBER (22) |
Internal key to audit_script_run |
|
FILE_TYPE |
VARCHAR2 (64) |
SQLLoaderLogFile, ShellOutputStream, ShellErrorStream, FTPOutputStream, or FTPErrorStream |
|
FILE_TEXT |
CLOB |
Contents of the file |
|
FORMAT |
VARCHAR2 (4000) |
TEXT or HTML |
|
CREATED_ON |
DATE |
The time the audit data was created |
|
CREATED_BY |
VARCHAR2 (30) |
Database username |
Table 1-8 ALL_RT_AUDIT_DEPLOYMENTS
| Column Name | Data Type | Description |
|---|---|---|
|
DEPLOYMENT_AUDIT_ID |
NUMBER(22) |
ID of the deployment audit |
|
DEPLOYMENT_AUDIT_NAME |
VARCHAR2(64) |
Name of the deployment audit |
|
NUMBER_OF_UNITS |
NUMBER(10) |
Number of units |
|
RUNTIME_VERSION |
VARCHAR2(64) |
Version of the control center |
|
CLIENT_VERSION |
VARCHAR2(64) |
Version of the Warehouse Builder client |
|
CLIENT_REPOSITORY |
VARCHAR2(30) |
Name of client repository |
|
CLIENT_REPOSITORY_VERSION |
VARCHAR2(64) |
Version of the client repository |
|
REPOSITORY_USER |
VARCHAR2(30) |
Name of the repository user |
|
GENERATION_TIME |
DATE |
Timestamp of the object generation |
|
DEPLOYMENT_AUDIT_STATUS |
VARCHAR2(4000) |
Status of the deployment |
|
NUMBER_SCRIPT_RUN_ERRORS |
NUMBER(10) |
Number of errors running the scripts within the deployment |
|
NUMBER_SCRIPT_RUN_WARNINGS |
NUMBER(10) |
Number of warnings while running the scripts within the deployment |
|
UPDATED_ON |
DATE |
Update timestamp |
|
CREATED_ON |
DATE |
Creation timestamp |
|
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
|
CREATED_BY |
VARCHAR2(40) |
Created by user |
Table 1-9 ALL_RT_INSTALLATIONS
| Column Name | Data Type | Description |
|---|---|---|
|
INSTALLATION_ID |
VARCHAR2 |
ID of the installation |
|
INSTALLATION_NAME |
CHAR |
Name of the installation |
|
DESCRIPTION |
CHAR |
Description of the installation |
|
INSTALLED_VERSION |
VARCHAR2(4000) |
Version of the repository that is installed |
|
RELEASE |
VARCHAR2 |
Release number of Warehouse Builder |
|
PUBLIC_VIEW_VERSION |
CHAR(4) |
Version of the PublicViews implemented by this installation |
|
SCHEMA_TYPE |
VARCHAR2(24) |
Type of schema |
|
UPDATED_ON |
VARCHAR2 |
Update timestamp |
|
CREATED_ON |
VARCHAR2 |
Creation timestamp |
| Column Name | Data Type | Description |
|---|---|---|
|
LOCATION_NAME |
VARCHAR2(64) |
Name of the location |
|
LOCATION_UOID |
VARCHAR2(32) |
UOID of the location |
|
IS_DEPLOYMENT_TARGET |
VARCHAR2(5) |
Indicates whether this location is a deployment target |
|
LOCATION_TYPE |
VARCHAR2(64) |
Type of the source or target with which the location is associated |
|
LOCATION_TYPE_VERSION |
VARCHAR2(64) |
Version of the source or target |
Table 1-11 ALL_RT_LOCATION_PARAMETERS
| Column Name | Data Type | Description |
|---|---|---|
|
LOCATION_NAME |
VARCHAR2(64) |
Name of the location |
|
PARAMETER_NAME |
VARCHAR2(64) |
Name of the parameter |
|
IS_ACCESS_RESTRICTED |
VARCHAR2(5) |
Indicates whether the parameter-value has a restricted value, such as for a password. |
|
PARAMETER_VALUE |
VARCHAR2(4000) |
The value of a non-access restricted parameter |
| Column Name | Data Type | Description |
|---|---|---|
|
OBJECT_NAME |
VARCHAR2(64) |
Name of the object |
|
OBJECT_TYPE |
VARCHAR2(64) |
Type of the object |
|
PARENT_OBJECT_NAME |
VARCHAR2(64) |
Name of the parent object |
|
PARENT_OBJECT_TYPE |
VARCHAR2(64) |
Type of the parent object |
|
LOCATION_NAME |
VARCHAR2(64) |
Name of the location to which this object is deployed |
|
OBJECT_UOID |
VARCHAR2(32) |
UOID of the object |
|
VERSION_TAG |
VARCHAR2(80) |
Version string used by Control Center Manager |
|
LAST_DEPLOYMENT_SCRIPT |
CLOB |
Script that was used during this objects last deployment |
|
STATUS_WHEN_LAST_DEPLOYED |
VARCHAR2(4000) |
Object status at the end of its last deployment |
|
SUB_OBJECTS_VALID |
VARCHAR2(5) |
Indicates whether the subobjects of an object were valid at last deployment |
|
RELATED_OBJECTS_VALID |
VARCHAR2(5) |
Indicates whether the related objects of an object were valid at last deployment |
|
DEPLOYMENT_DATE |
DATE |
Date the object was deployed |
|
DEPLOYED_BY |
VARCHAR2(30) |
User who deployed the object |
| Column Name | Data Type | Description |
|---|---|---|
|
CONTEXT_OBJECT_NAME |
VARCHAR2(64) |
Name of the tasks context |
|
CONTEXT_OBJECT_TYPE |
VARCHAR2(64) |
Type of the tasks context |
|
CONTEXT_LOCATION_NAME |
VARCHAR2(64) |
Name of the location where the context was deployed to |
|
EXEC_LOCATION_NAME |
VARCHAR2(64) |
Name of the location where the task will be executed |
|
TASK_NAME |
VARCHAR2(64) |
Name of the task |
|
TASK_TYPE |
VARCHAR2(64) |
Type of the task |
|
TASK_INPUT |
CLOB |
Script that implements the task |
|
OBJECT_NAME |
VARCHAR2(64) |
Name of the object |
|
OBJECT_TYPE |
VARCHAR2(64) |
Type of the object |
|
OBJECT_LOCATION_NAME |
VARCHAR2(64) |
Location to which the object is deployed |
Table 1-14 ALL_RT_TASK_PARAMETERS
| Column Name | Data Type | Description |
|---|---|---|
|
CONTEXT_OBJECT_NAME |
VARCHAR2(64) |
Name of the tasks context |
|
CONTEXT_OBJECT_TYPE |
VARCHAR2(64) |
Type of the tasks context |
|
CONTEXT_LOCATION_NAME |
VARCHAR2(64) |
Name of the location where the context was deployed to |
|
EXEC_LOCATION_NAME |
VARCHAR2(64) |
Name of the location where the task will be executed |
|
TASK_NAME |
VARCHAR2(64) |
Name of the task |
|
PARAMETER_KIND |
VARCHAR2(4000) |
Kind of Parameter |
|
CUSTOM_PARAMETER_UOID |
VARCHAR2(32) |
UOID of the parameter if it is a custom parameter |
|
PARAMETER_NAME |
VARCHAR2(64) |
Name of the parameter |
|
PARAMETER_TYPE |
VARCHAR2(4000) |
Type of the parameter |
|
PARAMETER_MODE |
VARCHAR2(4000) |
Mode of the parameter (IN/OUT/INOUT/VARIABLE) |
|
PARAMETER_SCOPE |
VARCHAR2(4000) |
Scope of the parameter (GLOBAL, SHARED, PARAMETER, LOCAL or INNER) |
|
BOUND_TO_NAME |
VARCHAR2(64) |
Name of object that the parameter might be bound to |
|
BOUND_TO_KIND |
VARCHAR2(4000) |
Kind of object that the parameter might be bound to |
|
BOUND_TO_SCOPE |
VARCHAR2(4000) |
Scope of the object that the parameter might be bound to |
|
IS_FIXED |
VARCHAR2(5) |
Is parameter value fixed |
|
IS_REQUIRED |
VARCHAR2(5) |
Is parameter value required |
|
TYPE_LENGTH |
NUMBER(10) |
Data type length of parameter |
|
TYPE_SCALE |
NUMBER(10) |
Data type scale of parameter |
|
TYPE_PRECISION |
NUMBER(10) |
Data type precision of parameter |
|
DEFAULT_VALUE_KIND |
NUMBER(8) |
Integer indicating kind of value (Literal, Expression, Evaluated Expression, Not Set) |
|
DEFAULT_VALUE |
VARCHAR2(4000) |
Default value for parameter |
Table 1-15 ALL_RT_AUDIT_EXECUTIONS
| Column Name | Data Type | Description |
|---|---|---|
|
EXECUTION_AUDIT_ID |
NUMBER (22) |
Internal primary key to audit_execution |
|
PARENT_EXECUTION_AUDIT_ID |
NUMBER (22) |
Internal key to parent audit_execution |
|
TOP_LEVEL_EXECUTION_AUDIT_ID |
NUMBER (22) |
Internal key to top-level audit_execution |
|
EXECUTION_NAME |
VARCHAR2 (64) |
Name of the execution run |
|
TASK_NAME |
VARCHAR2 (64) |
Name of the task executed |
|
TASK_TYPE |
VARCHAR2 (64) |
Type of task executed (PL/SQL, ProcessFlow). |
|
TASK_INPUT |
CLOB |
Input stream for the task |
|
EXEC_LOCATION_UOID |
VARCHAR2 (32) |
UOID of the location where execution is performed |
|
EXEC_LOCATION_NAME |
VARCHAR2 (64) |
Name of the location where execution is performed |
|
EXEC_LOCATION_TYPE |
VARCHAR2 (64) |
Type of the location where execution is performed. (Runtime Platform, OEM) |
|
EXEC_LOCATION_TYPE_VERSION |
VARCHAR2 (64) |
Version of the location where execution is performed |
|
OBJECT_UOID |
VARCHAR2 (32) |
Client UOID of mapping executed |
|
OBJECT_NAME |
VARCHAR2 (64) |
Name of mapping executed |
|
OBJECT_TYPE |
VARCHAR2 (64) |
Type of mapping executed |
|
OBJECT_LOCATION_UOID |
VARCHAR2 (32) |
Location UOID where mapping deployed |
|
OBJECT_LOCATION_NAME |
VARCHAR2 (64) |
Location name where mapping deployed |
|
OBJECT_LOCATION_TYPE |
VARCHAR2 (64) |
Location type where mapping deployed |
|
OBJECT_LOCATION_TYPE_VERSION |
VARCHAR2 (64) |
Location version where mapping deployed |
|
RETURN_RESULT |
VARCHAR2 (64) |
FAILURE, OK, OK_WITH_WARNINGS, or OK_WITH_ERRORS |
|
RETURN_CODE |
NUMBER (10) |
<0: Failure >= 0: Success |
|
EXECUTION_AUDIT_STATUS |
VARCHAR2 |
INACTIVE, BUSY, READY, or COMPLETE |
|
ELAPSE_TIME |
NUMBER (10) |
Number of seconds elapsed |
|
NUMBER_TASK_ERRORS |
NUMBER (10) |
Number of errors detected |
|
NUMBER_TASK_WARNINGS |
NUMBER (10) |
Number of warnings detected |
|
CREATED_ON |
DATE |
The time the audit data was created |
|
CREATED_BY |
VARCHAR2 (30) |
Database username |
|
UPDATED_ON |
DATE |
The time the audit data was updated |
|
UPDATED_BY |
VARCHAR2 (30) |
Database username |
Table 1-16 ALL_RT_AUDIT_EXECUTION_PARAMS
| Column Name | Data Type | Description |
|---|---|---|
|
PARAMETER_AUDIT_ID |
NUMBER (22) |
Internal primary key to audit_execution_param |
|
EXECUTION_AUDIT_ID |
NUMBER (22) |
Internal key to audit_execution |
|
CUSTOM_PARAMETER_UOID |
VARCHAR2 (32) |
UOID of custom parameter |
|
PARAMETER_NAME |
VARCHAR2 (64) |
Name of parameter |
|
PARAMETER_TYPE |
VARCHAR2(4000) |
BOOLEAN, CHAR, DATE, FLOAT, NUMBER, VARCHAR, VARCHAR2, OPERATING_MODE, or AUDIT_LEVEL |
|
PARAMETER_KIND |
VARCHAR2(4000) |
SYSTEM or CUSTOM |
|
PARAMETER_MODE |
VARCHAR2(4000) |
IN, OUT, or INOUT |
|
VALUE_KIND |
VARCHAR2 (12) |
INPUT VALUE or OUTPUT VALUE |
|
VALUE |
VARCHAR2 (4000) |
Character representation of parameter value |
Table 1-17 ALL_RT_AUDIT_EXEC_MESSAGES
| Column Name | Data Type | Description |
|---|---|---|
|
MESSAGE_AUDIT_ID |
NUMBER (22) |
Internal key to audit_exec_message. Primary key when used with message_line_number |
|
EXECUTION_AUDIT_ID |
NUMBER (22) |
Internal key to audit_execution |
|
MESSAGE_SEVERITY |
VARCHAR2 |
INFORMATIONAL, WARNING, ERROR, or RECOVERY |
|
MESSAGE_LINE_NUMBER |
NUMBER (10) |
1 for single line messages >0 for multiple line messages (Forms primary key when used with message_audit_id)) |
|
MESSAGE_TEXT |
VARCHAR2 (4000) |
Plain_text or nls_key |
|
CREATED_ON |
DATE |
The time the audit data was created |
|
CREATED_BY |
VARCHAR2 (30) |
Database username |
Table 1-18 ALL_RT_AUDIT_EXEC_FILES
| Column Name | Data Type | Description |
|---|---|---|
|
FILE_AUDIT_ID |
NUMBER (22) |
Internal primary key to audit_exec_file |
|
EXECUTION_AUDIT_ID |
NUMBER (22) |
Internal key to audit_execution |
|
FILE_TYPE |
VARCHAR2 (64) |
Type of the file |
|
FILE_TEXT |
CLOB |
Content of the file |
|
FORMAT |
VARCHAR2 |
TEXT or HTML |
|
CREATED_ON |
DATE |
The time the audit data was created |
|
CREATED_BY |
VARCHAR2 (30) |
Database username |
Table 1-19 ALL_RT_AUDIT_MAP_RUNS
| Column Name | Data Type | Description |
|---|---|---|
|
MAP_RUN_ID |
NUMBER (22) |
Internal primary key to audit_map_run |
|
EXECUTION_AUDIT_ID |
NUMBER (22) |
Internal key to audit_execution |
|
MAP_UOID |
VARCHAR2 (255) |
UOID of the mapping |
|
MAP_NAME |
VARCHAR2 (80) |
Name of the mapping |
|
MAP_TYPE |
VARCHAR2 (30) |
PLSQLMap or SQLLoaderControlFile |
|
START_TIME |
DATE |
The time the mapping started |
|
END_TIME |
DATE |
The time the mapping ended |
|
ELAPSE_TIME |
NUMBER (10) |
Number of seconds elapsed |
|
RUN_STATUS |
VARCHAR2 (8) |
RUNNING, FAILURE or COMPLETE |
|
PHYSICAL_NAME |
VARCHAR2 (80) |
Full hierarchic name of .dat file for a SQL*Loader run |
|
LOAD_DATE |
VARCHAR2 (30) |
Load date for a SQL*Loader run |
|
LOAD_TIME |
VARCHAR2 (30) |
Load time for a SQL*Loader run |
|
NUMBER_ERRORS |
NUMBER (10) |
Number of errors detected |
|
NUMBER_RECORDS_SELECTED |
NUMBER (10) |
Number of records selected from source tables |
|
NUMBER_RECORDS_INSERTED |
NUMBER (10) |
Number of records inserted into target tables |
|
NUMBER_RECORDS_UPDATED |
NUMBER (10) |
Number of records updated in target tables |
|
NUMBER_RECORDS_DELETED |
NUMBER (10) |
Number of records deleted in target tables |
|
NUMBER_RECORDS_DISCARDED |
NUMBER (10) |
Number of records discarded in SQL*Loader run |
|
NUMBER_RECORDS_MERGED |
NUMBER (10) |
Number of records merged in target tables |
|
NUMBER_RECORDS_CORRECTED |
NUMBER (10) |
Number of records corrected in target tables |
|
CREATED_ON |
DATE |
The time the audit data was created |
|
CREATED_BY |
VARCHAR2 (30) |
Database username |
|
UPDATED_ON |
DATE |
The time the audit data was updated |
|
UPDATED_BY |
VARCHAR2 (30) |
Database username |
Table 1-20 ALL_RT_AUDIT_MAP_RUN_SOURCES
| Column Name | Data Type | Description |
|---|---|---|
|
MAP_RUN_ID |
NUMBER (22) |
Internal key to audit_map_run |
|
SOURCE_NAME |
VARCHAR2 (2000) |
Name of mapping operator representing source table |
|
SOURCE_DBLINK |
VARCHAR2 (2000) |
Name of database link for mapping operator representing source table |
Table 1-21 ALL_RT_AUDIT_MAP_RUN_TARGETS
| Column Name | Data Type | Description |
|---|---|---|
|
MAP_RUN_ID |
NUMBER (22) |
Internal key to audit_map_run |
|
TARGET_NAME |
VARCHAR2 (2000) |
Name of mapping operator representing target table |
Table 1-22 ALL_RT_AUDIT_STEP_RUNS
| Column Name | Data Type | Description |
|---|---|---|
|
STEP_ID |
NUMBER (22) |
Internal primary key to audit_step_run |
|
MAP_RUN_ID |
NUMBER (22) |
Internal key to audit_map_run |
|
MAP_STEP |
NUMBER (22) |
Step number 0 or 1 For a PL/SQL mapping, this number is normally 0 for a set-based run, and 1 for a row-based, or row-based-target run |
|
STEP_NAME |
VARCHAR2 (80) |
Name of the mapping for a set-based run, or the name of a mapping object for a set-based or set-based-target run |
|
STEP_TYPE |
VARCHAR2 (18) |
Set-based, Row-based or Row-based target |
|
START_TIME |
DATE |
The time the mapping step started |
|
END_TIME |
DATE |
The time the mapping step ended |
|
ELAPSE_TIME |
NUMBER (10) |
Number of seconds taken |
|
RUN_STATUS |
VARCHAR2 (8) |
RUNNING or COMPLETE |
|
NUMBER_ERRORS |
NUMBER (10) |
Number of errors detected |
|
NUMBER_RECORDS_SELECTED |
NUMBER (10) |
Number of records selected from source tables |
|
NUMBER_RECORDS_INSERTED |
NUMBER (10) |
Number of records inserted into target tables |
|
NUMBER_RECORDS_UPDATED |
NUMBER (10) |
Number of records updated in target tables |
|
NUMBER_RECORDS_DELETED |
NUMBER (10) |
Number of records deleted in target tables |
|
NUMBER_RECORDS_DISCARDED |
NUMBER (10) |
Number of records discarded in a SQL*Loader run |
|
NUMBER_RECORDS_MERGED |
NUMBER (10) |
Number of records merged in target tables |
|
NUMBER_RECORDS_CORRECTED |
NUMBER (10) |
Number of records corrected in target tables |
|
CREATED_ON |
DATE |
The time the audit data was created |
|
CREATED_BY |
VARCHAR2 (30) |
Database username |
|
UPDATED_ON |
DATE |
The time the audit data was updated |
|
UPDATED_BY |
VARCHAR2 (30) |
Database username |
Table 1-23 ALL_RT_AUDIT_STEP_RUN_SOURCES
| Column Name | Data Type | Description |
|---|---|---|
|
STEP_ID |
NUMBER (22) |
Internal key to audit_step_run |
|
MAP_RUN_ID |
NUMBER (22) |
Internal key to audit_map_run |
|
MAP_STEP |
NUMBER (22) |
Step number 0 or 1 For a PL/SQL mapping, this number is normally 0 for a set-based run, and 1 for a row-based, or row-based-target run |
|
SOURCE_NAME |
VARCHAR2 (2000) |
Name of mapping operator representing source table |
|
SOURCE_DBLINK |
VARCHAR2 (2000) |
Name of database link for mapping operator representing source table |
Table 1-24 ALL_RT_AUDIT_STEP_RUN_TARGETS
| Column Name | Data Type | Description |
|---|---|---|
|
STEP_ID |
NUMBER (22) |
Internal key to audit_step_run |
|
MAP_RUN_ID |
NUMBER (22) |
Internal key to audit_map_run |
|
MAP_STEP |
NUMBER (22) |
Step number 0 or 1 For a PL/SQL mapping, this number is normally 0 for a set-based run, and 1 for a row-based, or row-based-target run |
|
TARGET_NAME |
VARCHAR2 (2000) |
Name of mapping operator representing target table |
Table 1-25 ALL_RT_AUDIT_MAP_RUN_ERRORS
| Column Name | Data Type | Description |
|---|---|---|
|
RUN_ERROR_ID |
NUMBER (22) |
Internal primary key for map_run_error |
|
STEP_ID |
NUMBER (22) |
Internal key to audit_step_run |
|
MAP_RUN_ID |
NUMBER (22) |
Internal key to audit_map_run |
|
MAP_STEP |
NUMBER (22) |
Step number 0 or 1 For a PL/SQL mapping, this number is normally 0 for a set-based run, and 1 for a row-based, or row-based-target run. |
|
CURSOR_ROWKEY |
NUMBER (22) |
Value identifying row returned by cursor. This is 0 for errors in a set-based run. |
|
RUN_ERROR_NUMBER |
NUMBER (10) |
Message number |
|
RUN_ERROR_MESSAGE |
VARCHAR2 (2000) |
Message text |
|
TARGET_NAME |
VARCHAR2 (80) |
Name of mapping operator representing target table |
|
TARGET_COLUMN |
VARCHAR2 (80) |
Column name, or '*' if not known or not applicable |
|
STATEMENT |
VARCHAR2 (2000) |
Value such as INSERT or BATCH INSERT, or a PL/SQL statement |
|
CREATED_ON |
DATE |
The time the audit data was created |
|
CREATED_BY |
VARCHAR2 (30) |
Database username |
|
UPDATED_ON |
DATE |
The time the audit data was updated |
|
UPDATED_BY |
VARCHAR2 (30) |
Database username |
Table 1-26 ALL_RT_AUDIT_MAP_RUN_TRACE
| Column Name | Data Type | Description |
|---|---|---|
|
TRACE_ID |
NUMBER (22) |
Internal primary key for map_run_trace |
|
MAP_RUN_ID |
NUMBER (22) |
Internal key to audit_map_run |
|
MAP_STEP |
NUMBER (22) |
Step number 0 or 1 For a PL/SQL mapping, this number is normally 0 for a set-based run, and 1 for a row-based, or row-based-target run |
|
CURSOR_ROWKEY |
NUMBER (22) |
Value identifying error row returned by cursor. This is 0 for set-based run |
|
TYPE |
VARCHAR2 (30) |
NEW for trace or ERROR for error |
|
ROLE |
VARCHAR2 (30) |
S for source or T for target |
|
ACTION |
VARCHAR2 (30) |
Value such as SELECT or a PL/SQL statement |
|
TABLE_NAME |
VARCHAR2 (80) |
Name of mapping operator representing source/target table |
|
CREATED_ON |
DATE |
The time the audit data was created |
|
CREATED_BY |
VARCHAR2 (30) |
Database username |
|
UPDATED_ON |
DATE |
The time the audit data was updated |
|
UPDATED_BY |
VARCHAR2 (30) |
Database username |
Table 1-27 ALL_RT_AUDIT_PROC_RUN_ERRORS
| Column Name | Data Type | Description |
|---|---|---|
|
RUN_ERROR_ID |
NUMBER(22) |
ID of the run error |
|
MAP_RUN_ID |
NUMBER(22) |
ID of the map run |
|
CURSOR_ROWKEY |
NUMBER(22) |
Rowkey of record returned by cursor when error reported |
|
RUN_ERROR_NUMBER |
NUMBER(10) |
Error number |
|
RUN_ERROR_MESSAGE |
VARCHAR2(2000) |
Error message |
|
TARGET_NAME |
VARCHAR2(2000) |
Name of target |
|
TARGET_COLUMN |
VARCHAR2(80) |
Name of target column |
|
STATEMENT |
VARCHAR2(2000) |
Statement when error is reported |
|
UPDATED_ON |
DATE |
Update timestamp |
|
CREATED_ON |
DATE |
Creation timestamp |
|
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
|
CREATED_BY |
VARCHAR2(40) |
Created by user |
Table 1-28 ALL_RT_AUDIT_STEP_RUN_STRUCTS
| Column Name | Data Type | Description |
|---|---|---|
|
STRUCT_ID |
NUMBER(22) |
ID of the structure |
|
STEP_ID |
NUMBER(22) |
ID of the step in the map |
|
MAP_RUN_ID |
NUMBER(22) |
ID of the run of the map |
|
PARENT_OPERATOR_UOID |
VARCHAR2(32) |
UOID of the map-operator being audited |
|
PARENT_OBJECT_UOID |
VARCHAR2(32) |
UOID of the parent object that the object is related to |
|
PARENT_OBJECT_TYPE |
VARCHAR2(30) |
Type of the parent object |
|
PARENT_OBJECT_LOCATION_UOID |
VARCHAR2(32) |
UOID of the location where the parent object has been deployed |
|
PARENT_OBJECT_NAME |
VARCHAR2(80) |
Name of the parent object |
|
OBJECT_UOID |
VARCHAR2(32) |
UOID of the object |
|
OBJECT_TYPE |
VARCHAR2(30) |
Type of the object |
|
OBJECT_LOCATION_UOID |
VARCHAR2(32) |
UOID of the location where the object has been deployed |
|
OBJECT_NAME |
VARCHAR2(80) |
Name of the object |
|
UPDATED_ON |
DATE |
Update timestamp |
|
CREATED_ON |
DATE |
Creation timestamp |
|
UPDATED_BY |
VARCHAR2(40) |
Updated by user |
|
CREATED_BY |
VARCHAR2(40) |
Created by user |
|
 Copyright © 2000, 2009, Oracle and/or its affiliates. All rights reserved. Legal Notices |
|
