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