Pipeline Views

Lists details for the DBMS_CLOUD_PIPELINE 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.
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.
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.
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.
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.
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.

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 `USER_LOAD_OPERATIONS` view for more information on data load operations.
`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 `USER_LOAD_OPERATIONS` view for more information on data load operations.
`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