Track DBMS_CLOUD Load Operations

DBMS_CLOUD tracks details for load operations for each instance and for users.

DBA_LOAD_OPERATIONS and USER_LOAD_OPERATIONS Views

USER_LOAD_OPERATIONS and DBA_LOAD_OPERATIONS views show the load operations in your schema or for all users. The USER_LOAD_OPERATIONS view does not display the USERNAME column.

Column Datatype NULL Description
ID NUMBER NOT NULL

Specifies the operation ID.
TYPE VARCHAR2(128) NOT NULL

Shows the operation type.
SID NUMBER NOT NULL

Session ID of the session.
SERIAL# NUMBER NOT NULL

USERNAME VARCHAR2(128) NOT NULL

User ID of the user performing the operation.

The USER_LOAD_OPERATIONS view does not display the USERNAME column.

START_TIME TIMESTAMP(6) WITH TIME ZONE  

Start time of the task.
UPDATE_TIME TIMESTAMP(6) WITH TIME ZONE  

Last update time for the task.
STATUS VARCHAR2(9)  

Status of the operation.

Valid values are: COMPLETED, FAILED, PENDING, RUNNING, SKIPPED.

OWNER_NAME VARCHAR2(128)  

Schema that owns the operation.
TABLE_NAME VARCHAR2(128)  

PARTITION_NAME VARCHAR2(128)  

SUBPARTITION_NAME VARCHAR2(128)  

FILE_URI_LIST VARCHAR2(4000)  

This value shows either a comma-delimited list of source file URIs or one or more directories and source files that were specified in the FILE_URI_LIST parameter.

ROWS_LOADED NUMBER  

Number of rows loaded in the load operation.
LOGFILE_TABLE VARCHAR2(128)  

Shows the name of the table you can query to look at the log of a load operation.
BADFILE_TABLE VARCHAR2(128)  

Shows the name of the table you can query to look at the rows that got errors during loading.
STATUS_TABLE VARCHAR2(128)  

Shows the name of the status table for the load operation.
TEMPEXT_TABLE VARCHAR2(128)  

CREDENTIAL_NAME VARCHAR2(128)  

EXPIRATION_TIME TIMESTAMP(9) WITH TIME ZONE