View and Retrieve Oracle Database Link Details查看和检索Oracle数据库的连接细节

In Oracle, database links are named objects that are created in one database which contains detail and instruction that describes how to connect to another, entirely different, database.在Oracle中，数据库链接被命名为对象，建立在一个数据库，其中包含详细的指示，说明如何连接到另一台，完全不同，数据库。 Database links are is a mean of performing distributed database processing, and can be used to retrieve data from a remote database of different version, or running on different operating system.数据库链接是指表演的分布式数据库处理，可用于检索数据从一个远程数据库的不同版本，或上运行不同的作业系统。

If you want to know whether any database links exist in data dictionary views, and where the database links connect to, you can get the information from DBA_DB_LINKS view.如果你想知道是否有任何数据库链接中存在的数据字典的意见，并在该数据库的链接连接到，你可以得到的资料，从dba_db_links的看法。

Just launch your SQL*Plus or Toad, or whatever convenient to you and query the dba_db_links table.刚刚启动SQL * Plus或蟾蜍，或任何方便你和查询dba_db_links表。 For example:例如：

SQL> select * from dba_db_links;的SQL > “选择*从dba_db_links ;

And you will be seeing listing of database links defined, with details of OWNER, DB_LINK, USERNAME, HOST, and CREATED, which the column name itself is more or less self-explanatory.您将看到上市的数据库链接的定义，与业主的细节， db_link ，用户名，主机，创造，这栏的名称本身就是更多或更少自我解释性。

Normally the OWNER of the database link is the person who created it, unless it was created as a public link, in which case a pseudo-user called PUBLIC is said to own it.通常是物主在该数据库的链接是人谁创造了它，除非它创造了作为一个公共的联系，在这种情况下，伪用户所谓的公众表示，自己的。

Beside, if you define connection host string as an entry (alias) from tnsnames.ora when creating the database links, the HOST column will show the tnsnameas alias, and not the host or remote server name that the database link is connecting to.旁边，如果您定义连线主机字符串作为一个进入（化名）从tnsnames.ora时，创造了数据库链接，东道国栏将显示tnsnameas别名，而不是主机或远程服务器名称该数据库连接是连接到。 You have to check tnsnames.ora to get the connection details.你必须检查tnsnames.ora获得连接的细节。

IMPORTANT : This is a machine translated page which is provided "as is" without warranty. 重要说明 ：这是一个机器翻译网页是“按原样”提供的担保。 Machine translation may be difficult to understand.机器翻译可能很难理解。 Please refer to请参阅 original English article英文原版的文章 whenever possible.只要有可能。

Share and contribute or get technical support and help at分享和贡献，或取得技术的支持和帮助，在 My Digital Life Forums 我的数字生活论坛 . 。

Related Articles相关文章

• Oracle Database Link Oracle数据库的连接
• Check Oracle Version检查的Oracle版本
• Oracle Database Import Error 3113/3114 Oracle数据库的进口错误三千一百一十四分之三千一百十三
• Change Oracle Database User Password改变Oracle数据库的用户密码
• Create, Add or Split Oracle Database Partition Fails with ORA-14080 Error创建，添加或分裂Oracle数据库分区失败，库存- 14080错误
• How Drop Tablespace and Recover Oracle Database When Accidentally Delete Datafile如何下拉表和恢复Oracle数据库时，不小心删除datafile
• Oracle EXP-00091 Error When Export Database甲骨文进出口- 00091时发生错误，进出口数据库
• Manual and Clean Uninstall Oracle for Windows手册和干净的卸载甲骨文为Windows
• Oracle JDeveloper Reviews甲骨文的JDeveloper评语
• Oracle ORA-01658 Unable to Create INITIAL Extent for Segment in Tablespace Error甲骨文库存- 01658无法建立初步的程度，为部分在表错误

This entry was posted on Thursday, March 9th, 2006 at 10:50 am and is filed under 此项目被张贴在周四， 2006年3月9日在上午10时50分，并提交下 Databases 数据库 . 。 You can follow any responses to this entry through the 您可以按照任何的反应，此项目通过 RSS 2.0 2.0 feed. 喂养。 You can 您可以 leave a response 留下的回应 , or ，或 trackback Trackback跟踪 from your own site. 从你自己的网站。