Oracle:db-link use

Two Oracle instance, if you need to directly query the data on another instance on a instance, use the Db-link

Create:

Create  Public Database Link name    to  by Password   ' ( DESCRIPTION = (      ADDRESS = (PROTOCOL = TCP) (HOST = server IP) (PORT = 1521))       (Connect_data =        (server = Dedic ATED)        (service_name =  orcltest))';

This creates a db-link, the above "link name", "User name", "password" and other parameters, we adjust it (Note: User name/password refers to the connection to another instance on the user name/password)

Use:

Select *  from table name @ link name

If you think "@ link name " is too cumbersome, you can use synonyms to simplify the operation

Oracle:db-link use