After you create a batch or single table import task in OceanBase Developer Center (ODC), you can view the task in the task list on the Import tab of the Task Center panel.
Task list
Note
The task list displays the tasks in the last 48 hours. ODC allows you to run up to three import tasks in parallel, while subsequent tasks wait in the queue.
On the management page of the database connection, click Task Center in the top navigation bar to open the Task Center panel. Click Import to display the list of import tasks.
The following table describes the columns in the task list. You can filter and sort tasks by some of the columns.
| Column | Description |
|---|---|
| Task ID | The ID of the import task. |
| Task Type | The task type specified when the task was created. The following task types are supported: import, export, data mocking, and database change. |
| Connection | The name of the database connection to which the task belongs. You can click the filter icon  to filter the tasks by connection. |
| Database | The database to be changed. You can click the search icon  to search for the database to which the task belongs. |
| Creator | The user who created the import task. You can click the search icon to search for the creator. |
| Creation Time | The date and time when the task was generated. |
| Task Status | The current status of the task. ODC provides different management actions for tasks in different states. |
| Actions | The actions you can take. Valid values: View , Approve/Reject , Abort , and Download . - View: Click this button to go to the task details page to view the task information and task logs. - Approve/Reject: Click this button to approve or reject a running task. - Abort: Click this button to abort a running task. - Download: Click this button to download the exported file to your local device when the task is complete. |
Create an import task
Log on to ODC and go to the management page of the target connection. On the Task Center panel that appears, click + on the right side of Export, and a new export task panel will pop up.
In the Create Import Task panel, specify the fields described in the following table.
Field Description Connection The name of the database connection to which the task belongs. Database The database to be changed. Operation Mode Select Automatically Perform after Approval or Manually Perform after Approval . Import Format Select SQL Files or ZIP Files . Import File Upload the file to be imported. Click the file pool to go to the file explorer and select the file to be imported. You can also directly drag the file to the file pool toupload it. Encoding Standard Select the character set from the drop-down list of Encoding Standard . Import Content You must specify this item when you select ZIP Files for Import Format . ODC currently supports Import Data Only , Import Schema Only , and Import Schema and Data . Data Format You must specify this item when you select ZIP Files for Import Format . ODC only supports importing data in CSV format and SQL format. For more information about formats, see Export and import formats. Import Data Settings If you specify ZIP Files for Import Format and Import Schema Only for Import Content , this step is not required. Task Error Handling Method Specify Task Error Handling Method . ODC supports two error handling methods: Abort Task and Ignore Error and Continue . You need to select the handling method under the Task Error Handling Method label. Sys Tenant Account Settings Configure Sys Tenant Account Settings . Select Use sys Account to Accelerate Import Task or not. If you select this option, you need to enter the account and password of the SYS tenant in the Account and Password fields. Then, you can use permissions of this account to import data, which accelerates the import task. Notice
- The account and password of a user in the SYS tenant are required. Do not enter @sys#cluster in the Account field. The following figure shows an example.
- To export objects other than tables and views, you must specify the SYS tenant account.
- Otherwise, annotations and indexes are not imported or exported.Click Import . The import task is created.
View an import task
Task information
Click View in the Actions column of the row where the target task is located. The task details panel appears. Click Task Information in the upper-right corner of the panel to view the basic task information, information about the imported files, and information about the imported objects.
| Item | Description |
|---|---|
| Basic information | Displays the basic information of the task, such as Task ID , Connection , Database , and Task Type . |
| Information about imported files | Displays information that you specified when you created the import task, such as Import Format , Import File , Encoding Standard , Import Content , Data Format , Import Data Settings , Task Error Handling Method , Sys Tenant Account Settings , and CSV Settings , |
| Information about imported objects | Displays the information of imported objects and the progress of the import task, such as Object Name , Object Type , Planned Processing Quantity , Actual Processing Quantity , and Data Processing Status . |
Task logs
Click View in the Actions column of the row where the target task is located. The task details panel appears. Click Task Logs in the upper-right corner of the panel to view the alert logs and all logs of the task.
| Field | Description |
|---|---|
| All Logs | Displays the INFO , ERROR , and WARN logs of the task. |
| Alert Logs | Displays the ERROR and WARN logs of the task. When a task fails, you can view the error message in the alert logs. |
In addition, the toolbar provides the following buttons: | Action | Description | |------|-----------------------------------------------------------| | Find | Click this option to find log information. | | Download | Click this option to download log information. | | Copy | Click this option to copy log information. |