DBMS_CLOUD_IMPORT Views
Describes the Autonomous AI Database DBMS_CLOUD_IMPORT views.
DBA_DATA_IMPORT_TASK_STATUS View
DBA_DATA_IMPORT_TASK_STATUS provides information about import tasks, including progress and execution details.
| Column Name | Datatype | Description |
|---|---|---|
TASK_NAME |
VARCHAR2(128) |
Name of the import task |
JOB_STATUS |
VARCHAR2(20) |
Current status of the import task. It indicates the percentage of import task completion |
SUMMARY |
CLOB |
Provides details such as the total number of schemas and tables to be migrated, along with the number successfully migrated |
ELAPSED_TIME |
TIMESTAMP |
Elapsed time of the import task |
CURRENTLY_LOADING |
CLOB |
Provides the table that is currently being loaded |
DBA_DATA_IMPORT_TABLE_STATUS View
DBA_DATA_IMPORT_TABLE_STATUS provides table-level migration tracking for an import task into Autonomous AI Database, showing which schema objects were created, their row/block counts and tablespace, the current status, any errors encountered, and the start/end timestamps for each table’s migration task.
| Column Name | Datatype | Description |
|---|---|---|
IMPORT_TASK_NAME |
VARCHAR2(128) |
Migration task name |
TABLE_TASK_NAME |
VARCHAR2(128) |
Task name specific to the table |
SCHEMA_NAME |
VARCHAR2(128) |
Schema name |
PARTITIONED |
VARCHAR2(3) |
Indicates whether the table is partitioned |
TABLESPACE_NAME |
VARCHAR2(30) |
Name of the tablespace |
STATUS |
VARCHAR2(20) |
Migration status of the table |
ERRORS |
CLOB |
Errors encountered during migration, if any |
CREATED_TS |
TIMESTAMP |
Timestamp when the table task was created |
COMPLETED_TS |
TIMESTAMP |
Timestamp when the table task was completed |