The creation of advanced Oracle Learning Dblink

The author of this paper simply explains that Oracle create Dblink,dblink is in a database directly to another database operation, it sounds wonderful, it is not difficult to implement, we just need to create a dblink on the database associated to another database on it, gossip less, Directly on the example:

If we are using a database now, we want to operate on the B database, we just need to execute the following statement:

The first B represents the name of the Dblink created on A, the second B represents the user name of the B database, PWD is the password, Host B's Ip,port is the port number of the B data, Service_Name is the instance name of B, and the execution is completed.

Create Public database link B

Connect to B identified by PWD

Using ' (DESCRIPTION =

(Address_list =

(ADDRESS = (PROTOCOL = TCP) (HOST =192.168.0.81) (PORT = 1521))

)

(Connect_data =

(service_name = ORCL)

)

)‘;

After the creation is complete, we can operate the B database on a.

Cases:

SELECT * from [email protected];

All data for the b_table table of B data is queried on a database.

Knowing this we can do what we want to do, you know, hope to help.

This article is from the Oracle Advanced blog, so be sure to keep this source http://shanghc.blog.51cto.com/6834610/1931144

The creation of advanced Oracle Learning Dblink