View existing DBLinks

After you create a DBLink, you can query the GV$DBLINK view to obtain the information about the DBLink, such as the tenant ID, DBLink ID, IP address and port number of the remote database, communication protocol, whether the DBLink is logged on, and whether the connected databases are heterogeneous.

Procedure

After you create a DBLink, execute the following statement to query the GV$DBLINK view:

obclient> SELECT * FROM GV$DBLINK;

For more information about fields in the GV$DBLINK view, see GV$DBLINK.

More information

For more information about operations on DBLinks, see the following topics:

• Create a DBLink

• Use a DBLink to access data in a remote database

• Use a DBLink to modify data in a remote database

• Drop a DBLink