Help Center/ Data Replication Service/ Troubleshooting/ Solutions to Failed Check Items/ Database Objects/ Checking Whether the Source Database Contains Unsupported Table Field Types
Updated on 2022-09-21 GMT+08:00

Checking Whether the Source Database Contains Unsupported Table Field Types

Oracle Migration and Synchronization

Table 1 Checking whether the source database contains unsupported table field types

Check Item

Whether the source database contains unsupported table field types

Description

Unsupported table field types are as follows: BFILE, XMLType, SDO_GEOMETRY, TIMESTAMP (x), INTERVAL DAY TO SECOND (x), and UROWID. The source database contains unsupported table field types, resulting in migration failures.

NOTE:
  • x indicates the precision. TIMESTAMP and INTERVAL DAY TO SECOND do not support the column type with precision between 7 to 9.
  • Due to internal restrictions, DRS cannot filter out special fields during data processing.

Failure Cause and Handling Suggestion

Failure cause: The source database contains unsupported table field types.

Handling suggestion: Delete the columns containing the unsupported field types. Alternatively, do not migrate the tables containing the unsupported table field types.

MySQL -> PostgreSQL Synchronization

Table 2 Checking whether the source database contains unsupported table field types

Check Item

Whether the source database contains unsupported table field types

Description

The following table fields types are not supported: geometry, point, lineString, polygon, geometrycollection, multipoint, multilinestring, and multipolygon. The source database contains unsupported table field types, resulting in migration failures.

Failure Cause and Handling Suggestion

Failure cause: The source database contains unsupported table field types.

Handling suggestion: Delete the columns containing the unsupported field types. Alternatively, do not migrate the tables containing the unsupported table field types.