SQL> CREATE PUBLIC DATABASE LINK LINKCKU CONNECT TO SFCS IDENTIFIED BY SFCS USING 'CKU' 2 /Database link createdSQL> CREATE PUBLIC SYNONYM SY_SFC_FACTORY FOR SFCS.SFC_FACTORY@CKU;Synonym createdSQL> SELECT * FROM SY_SFC_FACTORY;SELECT * FROM SY_SFC_FACTORYORA-02019: 未找到远程数据库的连接说明
ORA-02019 connection description for remote database not foundCause: An attempt was made to connect or log in to a remote database using a connection description that could not be found.Action: Specify an existing database link. Query the data dictionary to see all existing database links. See your operating system-specific Net8 documentation for valid connection descriptors. 你的select中是不是没有写 "@远程链接数据库名" 啊,如果没有的话,就不关同义词的事
上面写错了 SQL> CREATE PUBLIC SYNONYM SY_SFC_FACTORY FOR SFCS.SFC_FACTORY@LINKCKU;Synonym createdSQL> SELECT * FROM SY_SFC_FACTORY;SELECT * FROM SY_SFC_FACTORYORA-02085: 数据库链接LINKCKU.US.ORACLE.COM与ORACK相连结
SELECT * FROM SY_SFC_FACTORY@LINKCKUORA-02085: 数据库链接LINKCKU.US.ORACLE.COM与ORACK相连结
2 /Database link createdSQL> CREATE PUBLIC SYNONYM SY_SFC_FACTORY FOR SFCS.SFC_FACTORY@CKU;Synonym createdSQL> SELECT * FROM SY_SFC_FACTORY;SELECT * FROM SY_SFC_FACTORYORA-02019: 未找到远程数据库的连接说明
你的select中是不是没有写 "@远程链接数据库名" 啊,如果没有的话,就不关同义词的事
SQL> CREATE PUBLIC SYNONYM SY_SFC_FACTORY FOR SFCS.SFC_FACTORY@LINKCKU;Synonym createdSQL> SELECT * FROM SY_SFC_FACTORY;SELECT * FROM SY_SFC_FACTORYORA-02085: 数据库链接LINKCKU.US.ORACLE.COM与ORACK相连结