Note
This view is introduced since OceanBase Database V4.2.1.
Purpose
The DBA_OB_IMPORT_TABLE_JOBS view displays information about import jobs.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| JOB_ID | NUMBER(38) | NO | The ID of the job. |
| INITIATOR_TENANT_ID | NUMBER(38) | NO | The tenant ID of the parent job. |
| INITIATOR_JOB_ID | NUMBER(38) | NO | The ID of the parent job. |
| START_TIMESTAMP | VARCHAR2(256) | NO | The time on the tenant when the job was started. |
| FINISH_TIMESTAMP | VARCHAR2(256) | NO | The time on the tenant when the job was completed. |
| SRC_TENANT_NAME | VARCHAR2(64) | NO | The name of the source tenant. |
| SRC_TENANT_ID | NUMBER(38) | NO | The ID of the source tenant. |
| STATUS | VARCHAR2(64) | NO | The status of the job. Valid values:
|
| IMPORT_ALL | NUMBER(38) | NO | Indicates whether to import all tables in the tenant. The value is 1 if RECOVER TABLE *.* is specified, and is 0 in other scenarios. |
| DB_LIST | CLOB | YES | The databases to restore. |
| TABLE_LIST | CLOB | YES | The tables to restore. |
| REMAP_DB_LIST | CLOB | YES | The list of renamed databases, in the db1:new_db1, db2:newdb2 format. |
| REMAP_TABLE_LIST | CLOB | YES | The list of renamed tables, in the db1.t1:new_t1, db1.t2:db2.new_t2 format. |
| REMAP_TABLEGROUP_LIST | CLOB | YES | The list of remapped table groups in the tg1:new_tg1, tg2:new_tg2 format. You can remap a table from the original table group to the target table group. |
| REMAP_TABLESPACE_LIST | CLOB | YES | The list of remapped tablespaces, in the ts1:new_ts1, ts2:new_ts2 format. You can remap a table from the original tablespace to the target tablespace. |
| TOTAL_TABLE_COUNT | NUMBER(38) | NO | The total number of tables to import. |
| FINISHED_TABLE_COUNT | NUMBER(38) | NO | The number of tables imported. |
| FAILED_TABLE_COUNT | NUMBER(38) | NO | The number of tables failed to be imported. |
| RESULT | VARCHAR2(64) | YES | The result of the table-level restore job. Valid values:
|
| COMMENT | CLOB | YES | The additional information. |
| DESCRIPTION | CLOB | YES | The description specified in the restore statement. |