Background information
ODC V4.3.2 and later versions support making changes to data in logical databases. You can run time-consuming SQL statements through a logical database change task to avoid statement execution timeout.
Note
- If you do not have logical database permissions, you can apply for them via Apply for Database Permissions in the project/ticket section.
- For information on logical databases and physical databases, see Logical Database Management.
Considerations
Only OceanBase MySQL and MySQL data sources are supported.
Only DDL changes are supported.
SQL check specifications and SQL window specifications in ODC security guidelines are not supported.
Create a logical database change task
In Project/Ticket, click Logical Database Change.
Create a logical database change from the project entry.
Create a logical database change from the ticket entry.
On the Create Logical Database Change page, enter the following information.
Information ItemDescriptionLogical Database Select the logical database to be changed. SQL Content Select SQL Entry: SQL entry is the default method, allowing you to directly enter the SQL script in the editing area. Note
- In SQL entry, a maximum of 500,000 characters are allowed. If exceeded, you can upload an attachment.
- Click IN Value Conversion to convert batch copied data into the in('A','B') format.
- Column value separator is a line break character.
- Row value separator is a space or TAB character.
Separator Supports Delimiter as the separator. Task Settings Select Immediate Execution / Scheduled Execution to set the task execution method. Execution Timeout Enter a number in the Execution Timeout text box to specify the statement execution timeout, in hours (default timeout is 48 hours, with a maximum of 480 hours). Description You can enter up to 200 characters of descriptive information in the Ticket Description text box. This item is optional. Click Create to complete creating the logical database change.
After the task is generated, you can view its information in the Ticket > Logical Database Change list.
View a logical database change task
Task information
In the logical database change list on the Ticket page, as shown above, click the View button under the Actions column for the task you want to view.
In the task details panel that appears, click the Basic Information tab to view information such as the logical database, task type, risk level, and SQL content.
Click Initiate Again to re-initiate the logical database change task.
Task process
In the task details panel, click the Workflow tab to view information such as the task initiation status, approval status, execution status, and execution result.
Execution records
In the task details panel, click the Execution Records tab to view the task execution status.
Task logs
In the task details panel, click the Logs tab to view all logs and alert logs of the task.
Information Item |
Description |
|---|---|
| All Logs | All logs display the full information of tasks, including INFO, ERROR, and WARN logs. You can click the Find, Download, or Copy button to search for information, download, or copy all log information. |
| Alert Log | The alert log displays only the ERROR and WARN logs of a task. When a task fails, you can view the error information in the alert log. Click the Find, Download, or Copy button to search for information, download, or copy the alert log. |