How to fix the Oracle error ORA-26690: datatype not supported at non-Oracle system?

In this post, you’ll learn more about the Oracle ErrorORA-26690: datatype not supported at non-Oracle system with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-26690: datatype not supported at non-Oracle system

Reason for the Error ORA-26690: datatype not supported at non-Oracle system

One of the columns of the LCR being applied was of a datatype not supported by either the target non-Oracle system or by the Oracle transparent gateway through which the apply is being done.

How to fix the Error ORA-26690: datatype not supported at non-Oracle system ?

You can fix this error in Oracle by following the below steps

Do not apply data of this type. If possible, filter out columns containing such datatypes before applying.