Checking the Length of the Index Column in the Source Database

Checking the length of the index column in the source database

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

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);