ORA-12704: unable to convert character data

Question

I am trying to execute SET operations in Oracle through remote databases. I am using the MINUS statement.

My query looks something like this.

SELECT NAME FROM localdb MINUS SELECT NAME from remotedb@dblink

This causes error ORA-12704. I understand that this requires some kind of conversion or NLS configuration.

What should I do next?

Answer 1

Two columns nameare stored in different character sets. This may be due to their type definitions, or it may be due to the fact that the two databases use different character sets.

You may be able to get around this by explicitly converting the field from the remote database to the local character set. Try the following:

SELECT NAME FROM localdb MINUS SELECT TO_CHAR(NAME) from remotedb@dblink

Answer 2

NAME .

, NAME remotedb NAME localdb. , MINUS.