Pipeline Views
Lists details for the DBMS_CLOUD_PIPELINE views.
- DBA_CLOUD_PIPELINES View
DBA_CLOUD_PIPELINESdisplays the list of pipelines created in the database. The view contains one row for each pipeline. - USER_CLOUD_PIPELINES View
USER_CLOUD_PIPELINESdisplays the list of pipelines created in the database for the user. The view contains one row for each pipeline. - DBA_CLOUD_PIPELINE_HISTORY View
DBA_CLOUD_PIPELINE_HISTORYlists the pipeline scheduled jobs in the database. Use this view to monitor the health of the pipeline and detect failures in pipeline job runs. - USER_CLOUD_PIPELINE_HISTORY View
USER_CLOUD_PIPELINE_HISTORYlists the pipeline scheduled jobs in the database for the user. Use this view to monitor the health of the pipeline and detect failures in pipeline job runs. - DBA_CLOUD_PIPELINE_ATTRIBUTES View
DBA_CLOUD_PIPELINE_ATTRIBUTESlists the attributes of a pipelines in the database. Attributes control the configuration and behavior of the pipeline jobs. - USER_CLOUD_PIPELINE_ATTRIBUTES View
USER_CLOUD_PIPELINE_ATTRIBUTESlists the attributes of a pipelines in the database for the user. Attributes control the configuration and behavior of the pipeline.
Parent topic: Autonomous Database Views
DBA_CLOUD_PIPELINES View
DBA_CLOUD_PIPELINES displays the list of pipelines
created in the database. The view contains one row for each pipeline.
| Column | Datatype | NULL | Description |
|---|---|---|---|
PIPELINE_ID |
NUMBER |
NOT NULL |
Unique number assigned to the pipeline. |
PIPELINE_NAME |
VARCHAR2(128) |
NOT NULL |
Name of the pipeline. |
OWNER |
VARCHAR2(128) |
NOT NULL |
Owner schema of the pipeline |
PIPELINE_TYPE |
VARCHAR2(7) |
NOT NULL |
Type of pipeline: LOAD or
EXPORT |
STATUS |
VARCHAR2(7) |
NOT NULL |
Current status of pipeline: STARTED or
STOPPED |
DESCRIPTION |
VARCHAR2(4000) |
User specified description for the pipeline. | |
CREATED |
TIMESTAMP(6) WITH TIME ZONE |
NOT NULL |
Creation time for the pipeline. |
LAST_MODIFIED |
TIMESTAMP(6) WITH TIME ZONE |
NOT NULL |
Last modification time for the pipeline. |
LAST_EXECUTION |
TIMESTAMP(6) WITH TIME ZONE |
Last successful execution time of pipeline job. | |
OPERATION_ID |
NUMBER |
Is the Operation ID for use with pipeline logs. See Monitor and Troubleshoot Pipelines for information on the |
|
STATUS_TABLE |
VARCHAR2(128) |
Status Table for pipeline progress. This is applicable for Load Pipelines. | |
ORACLE_MAINTAINED |
CHAR(1) |
NOT NULL |
Indicates whether pipeline is Oracle maintained
(Y) or not (N).
|
Parent topic: Pipeline Views
USER_CLOUD_PIPELINES View
USER_CLOUD_PIPELINES displays the list of pipelines
created in the database for the user. The view contains one row for each
pipeline.
| Column | Datatype | NULL | Description |
|---|---|---|---|
PIPELINE_ID |
NUMBER |
NOT NULL |
Unique number assigned to the pipeline. |
PIPELINE_NAME |
VARCHAR2(128) |
NOT NULL |
Name of the pipeline. |
PIPELINE_TYPE |
VARCHAR2(7) |
NOT NULL |
Type of pipeline: LOAD or
EXPORT |
STATUS |
VARCHAR2(7) |
NOT NULL |
Current status of pipeline: STARTED or
STOPPED |
DESCRIPTION |
VARCHAR2(4000) |
User specified description for the pipeline. | |
CREATED |
TIMESTAMP(6) WITH TIME ZONE |
NOT NULL |
Creation time for the pipeline. |
LAST_MODIFIED |
TIMESTAMP(6) WITH TIME ZONE |
NOT NULL |
Last modification time for the pipeline. |
LAST_EXECUTION |
TIMESTAMP(6) WITH TIME ZONE |
Last successful execution time of pipeline job. | |
OPERATION_ID |
NUMBER |
Is the Operation ID for use with pipeline logs. See Monitor and Troubleshoot Pipelines for information on the |
|
STATUS_TABLE |
VARCHAR2(128) |
Status Table for pipeline progress. This is applicable for Load Pipelines. | |
ORACLE_MAINTAINED |
CHAR(1) |
NOT NULL |
Indicates whether pipeline is Oracle maintained
(Y) or not (N).
|
Parent topic: Pipeline Views
DBA_CLOUD_PIPELINE_HISTORY View
DBA_CLOUD_PIPELINE_HISTORY lists the pipeline
scheduled jobs in the database. Use this view to monitor the health of the pipeline and
detect failures in pipeline job runs.
| Column | Datatype | NULL | Description |
|---|---|---|---|
PIPELINE_ID |
NUMBER |
NOT NULL |
Unique number assigned to the pipeline. |
PIPELINE_NAME |
VARCHAR2(128) |
NOT NULL |
Name of the pipeline |
OWNER |
VARCHAR2(128) |
NOT NULL |
Owner schema of the pipeline. |
PIPELINE_TYPE |
VARCHAR2(7) |
Type of pipeline: LOAD or
EXPORT |
|
JOB_ID |
NUMBER |
NOT NULL |
Unique ID for the pipeline job execution. |
JOB_NAME |
VARCHAR2(1044) |
Unique job name for the pipeline execution. | |
STATUS |
VARCHAR2(30) |
Status of the pipeline job. | |
START_DATE |
TIMESTAMP(9) WITH TIME ZONE |
Start time of the pipeline job execution. | |
END_DATE |
TIMESTAMP(9) WITH TIME ZON |
End time of the pipeline job execution. | |
INSTANCE_ID |
NUMBER |
Instance ID where the pipeline job ran. | |
SESSION_ID |
VARCHAR2(128) |
Session ID for the job session. | |
ERROR_NUMBER |
NUMBER |
Error number in the job (if encountered). | |
ERROR_MESSAGE |
VARCHAR2(4000) |
Error message in the job (if encountered). | |
CPU_USED |
INTERVAL DAY(3) TO SECOND(2) |
Number of CPU used by the pipeline job run. | |
JOB_OUTPUT |
CLOB |
Debug output of the pipeline job run. |
Parent topic: Pipeline Views
USER_CLOUD_PIPELINE_HISTORY View
USER_CLOUD_PIPELINE_HISTORY lists the pipeline
scheduled jobs in the database for the user. Use this view to monitor the health of the
pipeline and detect failures in pipeline job runs.
| Column | Data Type | NULL | Description |
|---|---|---|---|
PIPELINE_ID |
NUMBER |
NOT NULL |
Unique number assigned to the pipeline. |
PIPELINE_NAME |
VARCHAR2(128) |
NOT NULL |
Name of the pipeline |
PIPELINE_TYPE |
VARCHAR2(7) |
Type of pipeline: LOAD or
EXPORT |
|
JOB_ID |
NUMBER |
NOT NULL |
Unique ID for the pipeline job execution. |
JOB_NAME |
VARCHAR2(1044) |
Unique job name for the pipeline execution. | |
STATUS |
VARCHAR2(30) |
Status of the pipeline job. | |
START_DATE |
TIMESTAMP(9) WITH TIME ZONE |
Start time of the pipeline job execution. | |
END_DATE |
TIMESTAMP(9) WITH TIME ZON |
End time of the pipeline job execution. | |
INSTANCE_ID |
NUMBER |
Instance ID where the pipeline job ran. | |
SESSION_ID |
VARCHAR2(128) |
Session ID for the job session. | |
ERROR_NUMBER |
NUMBER |
Error number in the job (if encountered). | |
ERROR_MESSAGE |
VARCHAR2(4000) |
Error message in the job (if encountered). | |
CPU_USED |
INTERVAL DAY(3) TO SECOND(2) |
Number of CPU used by the pipeline job run. | |
JOB_OUTPUT |
CLOB |
Debug output of the pipeline job run. |
Parent topic: Pipeline Views
DBA_CLOUD_PIPELINE_ATTRIBUTES View
DBA_CLOUD_PIPELINE_ATTRIBUTES lists the attributes of
a pipelines in the database. Attributes control the configuration and behavior of the
pipeline jobs.
| Column | Datatype | NULL | Description |
|---|---|---|---|
PIPELINE_ID |
NUMBER |
NOT NULL |
Unique number assigned to the pipeline. |
PIPELINE_NAME |
VARCHAR2(128) |
NOT NULL |
Name of the pipeline. |
OWNER |
VARCHAR2(128) |
NOT NULL |
Owner schema of the pipeline |
PIPELINE_TYPE |
VARCHAR2(7) |
NOT NULL |
Type of pipeline: LOAD or
EXPORT |
ATTRIBUTE_NAME |
VARCHAR2(128) |
NOT NULL |
Name of the pipeline attribute. |
ATTRIBUTE_VALUE |
CLOB |
Value of the pipeline attribute. | |
LAST_MODIFIED |
TIMESTAMP(6) WITH TIME ZONE |
NOT NULL |
Last modification time for the pipeline attribute. |
Parent topic: Pipeline Views
USER_CLOUD_PIPELINE_ATTRIBUTES View
USER_CLOUD_PIPELINE_ATTRIBUTES lists the attributes
of a pipelines in the database for the user. Attributes control the configuration and
behavior of the pipeline.
| Column | Datatype | NULL | Description |
|---|---|---|---|
PIPELINE_ID |
NUMBER |
NOT NULL |
Unique number assigned to the pipeline. |
PIPELINE_NAME |
VARCHAR2(128) |
NOT NULL |
Name of the pipeline. |
PIPELINE_TYPE |
VARCHAR2(7) |
NOT NULL |
Type of pipeline: LOAD or
EXPORT |
ATTRIBUTE_NAME |
VARCHAR2(128) |
NOT NULL |
Name of the pipeline attribute. |
ATTRIBUTE_VALUE |
CLOB |
Value of the pipeline attribute. | |
LAST_MODIFIED |
TIMESTAMP(6) WITH TIME ZONE |
NOT NULL |
Last modification time for the pipeline attribute. |
Parent topic: Pipeline Views