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_OPERATIONSandDBA_LOAD_OPERATIONSviews show the load operations in your schema or for all users. TheUSER_LOAD_OPERATIONSview does not display theUSERNAMEcolumn.
Parent topic: Autonomous Database Views
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 |
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: |
|
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 |
|
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 |
Parent topic: Track DBMS_CLOUD Load Operations