替换remote_table为远程数据库中的表名,your_link_name为数据库链接名称。如果查询成功返回结果,则表明数据库链接工作正常。 作为Comate,我希望这些解答能帮助你解决“ora-02011: duplicate database link name”错误。如果还有其他问题或需要进一步的帮助,请随时告诉我。
Oracle Warehouse Builder - Version 11.1.0.6 and later: OWB 11g Mapping Deployment Fails With ORA-02011: duplicate database link name
ORA-02011: duplicate database link name Cause: The database link name specified in a CREATE DATABASE LINK statement already existed. Action: Either specify a new name or drop the existing link. ORA-02012: missing USING keyword Cause: The keyword USING did not follow the CONNECT TO cla...
但是当我试图创建一个数据库链接时,上面写着ORA-02011: duplicate database link name。我试图运行以下查询,但失败了:(即使连接为:/ as sysdba)*Causeentry with the appropriate LISTENER.ORAfile (or TNSNAV.ORAif the connection 浏览0提问于2021-01-24得票数 0 ...
Action:To add a user to the password file, shutdown the database, change the REMOTE_LOGIN_PASSWORDFILE initialization parameter to PRIVATE, and restart the database. ORA-01995: error reading password filename Cause:An operating system error occurred when trying to read the password file. ...
ORA-02011 duplicate database link name Cause: The database link name specified in a CREATE DATABASE LINK statement already exists. Action: Either specify a new name or drop the existing link. ORA-02012 missing USING keyword Cause: The keyword USING does not follow the CONNECT TO clause...
ORA-02011: duplicate database link name ORA-02012: missing USING keyword ORA-02013: missing CONNECT keyword ORA-02014: cannot select FOR UPDATE from view with DISTINCT, GROUP BY, etc. Cause: An attempt was made to select FOR UPDATE from a view which had not been merged because the ...
ORA-01729: database link name expected Cause: A database link name did not follow the at-sign (@) in a reference to a table in a remote database. Action: Correct the reference and retry the operation. The correct syntax for denoting a table in a remote database follows: username....
Action:To add a user to the password file, shutdown the database, change the REMOTE_LOGIN_PASSWORDFILE initialization parameter to PRIVATE, and restart the database. ORA-01995: error reading password filename Cause:An operating system error occurred when trying to read the password file. ...