A Brief Introduction to two ways to create a Database Link in Oracle

OracleHow to Create a databaseDatabase LinkWhat about it? This article mainly introduces this part. There are two ways to create a Database Link in Oracle Database: menu and SQL.

Create A dblink named dblink_name, which is connected from database A to database B. Database B has the IP address 192.168.1.73, port 1521, Instance name oracle, login name tast, and password test.

Menu mode:

Open plsql, click File> New> Database link to open the window shown in

After filling in the information, click Apply to create the Database Link.

SQL Method

 
 


  
  
-- Drop existing database link

  
  
Drop public database link dblink_name;

  
  
 

  
  
-- Create database link

  
  
Create public database link dblink_name

  
  
Connect to SYSTEM

  
  
Using '1970. 168.1.73: 192/oracle ';

 
 

The above two methods are used to create a Database Link in Oracle. We will introduce this article. If you want to know