来自另一个ORACLE数据库的查询表

(This will require an appropriate matching entry in the tnsnames.ora file on the Oracle server, or the oracle names server, or the connection details can be spelled out in place of a tnsnames.ora entry, something like:CREATE DATABASE LINK UADEVORADB CONNECT TO user IDENTIFIED BY password USING '(DESCRIPTION= (ADDRESS=(PROTOCOL=TCP)(HOST=uadevorahost1)(PORT=1521)) (CONNECT_DATA=(SERVICE_NAME=uadevoradb.domaindb)))'如果在数据库链接中指定的用户"与远程系统上表的所有者"不同，并且没有引用该表的同义词，则表标识符将需要与所有者进行限定...If the "user" specified in the database link differs from the "owner" of the table on the remote system, and there's no synonym that references the table, the table identifier will need to be qualified with the owner...SELECT * FROM OWNER.TABLE_NAME@UADEVORADB ; 这篇关于来自另一个ORACLE数据库的查询表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！ 上岸，阿里云！