Purpose
The oceanbase.DBA_OB_IMPORT_TABLE_JOBS view provides information about import jobs.
Note
This view is introduced since OceanBase Database V4.2.1.
Columns
Column |
Type |
Nullable? |
Description |
|---|---|---|---|
| JOB_ID | bigint(20) | NO | The ID of the job. |
| INITIATOR_TENANT_ID | bigint(20) | NO | The tenant ID of the parent job. |
| INITIATOR_JOB_ID | bigint(20) | NO | The ID of the parent job. |
| START_TIMESTAMP | timestamp(6) | NO | The time on the tenant when the job started. |
| FINISH_TIMESTAMP | timestamp(6) | NO | The time on the tenant when the job was completed. |
| SRC_TENANT_NAME | varchar(64) | NO | The name of the source tenant. |
| SRC_TENANT_ID | bigint(20) | NO | The ID of the source tenant. |
| STATUS | varchar(64) | NO | The status of the job. Valid values:
|
| IMPORT_ALL | tinyint(4) | 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 | longtext | YES | The database to restore. |
| TABLE_LIST | longtext | YES | The tables to restore. |
| REMAP_DB_LIST | longtext | YES | The remappings of databases, in the format of db1:new_db1, db2:newdb2. |
| REMAP_TABLE_LIST | longtext | YES | The remappings of tables, in the format of db1.t1:new_t1, db1.t2:db2.new_t2. |
| REMAP_TABLEGROUP_LIST | longtext | YES | The remappings of table groups, in the format of tg1:new_tg1, tg2:new_tg2. You can remap a table from the original table group to the target table group. |
| REMAP_TABLESPACE_LIST | longtext | YES | The remappings of tablespaces, in the format of ts1:new_ts1, ts2:new_ts2. You can remap a table from the original tablespace to the target tablespace. |
| TOTAL_TABLE_COUNT | bigint(20) | NO | The total number of tables to import. |
| FINISHED_TABLE_COUNT | bigint(20) | NO | The number of tables imported. |
| FAILED_TABLE_COUNT | bigint(20) | NO | The number of tables failed to be imported. |
| RESULT | varchar(64) | YES | The result of the table-level restore job. Valid values:
|
| COMMENT | longtext | YES | The additional information. |
| DESCRIPTION | longtext | YES | The description specified in the restore statement. |