Help Center/ Data Replication Service/ Troubleshooting/ Solutions to Failed Check Items/ Database Parameters/ Checking the Length of the Index Column in the Source Database
Updated on 2022-09-06 GMT+08:00
View PDF
Share

Checking the Length of the Index Column in the Source Database

Oracle to MySQL Synchronization

Table 1 Checking the length of the index column in the source database

Check Item

Checking the length of the index column in the source database

Description

Check whether the length of index column in the source database exceeds the limit.

Failure Cause and Handling Suggestion

Failure cause: The source database contains a data table with more than 64 indexes.

Handling suggestion: Do not synchronize indexes or delete some indexes so that the number of indexes in a single table in the source database does not exceed 64.

Statement for deleting an index:

DROP INDEX index_name;

Failure cause: There are indexes in the source database exceed the column length limit of the destination database.

Handling suggestion: Deselect the table or change the index length.

Statement for deleting an index:

DROP INDEX index_name;

Statement for creating an index:

CREATE INDEX index_name ON table_name(col1,col2);
Parent topic: Database Parameters