I've created a DBlink on Oracle database 220.127.116.11 to access a remote Oracle database 18.104.22.168 but when I try to select a table the following message is displayed
SQL> select * from owner.table1@ORCL;
select * from owner.table1@ORCL
ERROR at line 1:
ORA-00096: invalid value BYTE for parameter nls_length_semantics, must be from
ORA-02063: preceding line from ORCLDB01
Please let me know what can I do to fix this issue.
I tried your recommendation but I recieved this message:
"SQL> alter session set nls_length_semantics='CHAR';
ORA-00096: invalid value CHAR for parameter nls_length_semantics, must be from
Is this issue specific to single table? If yes, could you describe the table and post the datatypes of the columns?
Altering NLS_LENGTH_SEMANTICS will be helpful only if you create any new object. This may not be helpful in this case.
Pls post the database characterset and national character set of the remote database.