Remote access using an Oracle DBLink

Printer-friendly version

The easiest way to access from an Oracle database to objects of another Oracle database is using a DBLink (this does not mean that it is always the most desirable, abuse of DBLinks can generate both performance as security problems).

First, you need a user who holds the create database link privilege. Then, you can create DBLink in source database (A) through this simple sentence:

  • create database link lnk_from_A_a_B connect to user identified by password using 'B';

- 'lnk_from_A_a_B ' is the link name,

- 'user' and 'password' are the user identifiers who will use the link to connect.

- 'B' is the SID of the target database.

Through this DBLink you can connect with objects in the remote database with privileges owned by the user of the creation sentence.

To reference an object of the remote database should indicate object name concatenated with '@' and the DBLink name.

Example: select * from mytable@lnk_from_A_a_B

 

Well, personally, I have

Submitted by kidilam on 10 February, 2011 - 13:07.

Well, personally, I have found DB links to be the simplest method of accessing from an Oracle Database to another Oracle database. But like it is said here, it isn’t certainly without its flaws. I have often seen many performance issues related with the abuse of DB links and even worse is when it affects the security. That being said, if you use it correctly and appropriately, I don’t think there would be such an issue to worry about! business continuity planning software

Google
 
     

Saas as a response to the barriers to the automation of supplier invoices in Europe.
Just before summer, Esker IDC commissioned a study on the state of the market of managing vendor invoices in Europe. This study, which in terms of pure IDC is a "White...
List of visualization tools
Great collection of tools that allow us to include motion graphics, maps, etc ...
Mini video tutorials: Eclipse, JBoss Tools / Struts, iReports / Struts
Good, then I present a series of video tutorials that have made ​​my colleague Mariano Mattio (member of eglue BI ) and has decided to share with the community. Thanks Mariano...
Ora10g: Looking activity "extra-ordinary" in our database with TOAD
There are people for and against this tool but for me it is most useful for specific tasks and as a supplement. In fact the person who was in my post gave a very bad reputation...
The video game industry a Blue Ocean
At present the blue ocean strategy is becoming more important for those you have not heard of it, was made ​​by W. Kim Chan in his book "Blue Ocean Strategy." The...
Talend ETL Cliente.Tipos Dimension Mapping for lookup. Management of SCD (slowly changing dimensions).
Enobia The project continues to progress in the more complex and probably will consume more resources, ETL processes. As already noted, some projects can be up to 80% of the time...