DBMS_CLOUD_IMPORT Views
Describes the Autonomous AI Database DBMS_CLOUD_IMPORT views.
Topics
- DBA_DATA_IMPORT_TASK_STATUS View
DBA_DATA_IMPORT_TASK_STATUSprovides information about import tasks, including progress and execution details. - DBA_DATA_IMPORT_TABLE_STATUS View
DBA_CONVERTED_STATEMENTSprovides 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.
Parent topic: Autonomous AI Database Views
DBA_DATA_IMPORT_TASK_STATUS View
DBA_DATA_IMPORT_TASK_STATUS provides information about import tasks, including progress and execution details.
| Column Name | Data Type | Description |
|---|---|---|
|
|
|
Name of the import task |
|
|
|
Current status of the import task. It indicates the percentage of import task completion |
|
|
|
Provides details such as the total number of schemas and tables to be migrated, along with the number successfully migrated |
|
|
|
Elapsed time of the import task |
|
|
|
Provides the table that is currently being loaded |
Parent topic: DBMS_CLOUD_IMPORT Views
DBA_DATA_IMPORT_TABLE_STATUS View
DBA_CONVERTED_STATEMENTS 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 | Data type | Description |
|---|---|---|
|
|
|
Migration task name |
|
|
|
Task name specific to the table |
|
|
|
Schema name |
|
|
|
Schema object (e.g., table name) |
|
|
|
Indicates whether the table is partitioned |
|
|
|
Name of the tablespace |
|
|
|
Migration status of the table |
|
|
|
Errors encountered during migration, if any |
|
|
|
Timestamp when the table task was created |
|
|
|
Timestamp when the table task was completed |
Parent topic: DBMS_CLOUD_IMPORT Views