Specific steps for implementing Oracle cross-Server

The following articles mainly describe the specific Oracle cross-server operations. This article mainly uses the actual application code to introduce the specific Oracle cross-server operation solution, the following describes the specific content of the article. I hope you will gain some benefits after visiting the article.

 
 

  
  
SQL code
  
  
Create public database link test_link
  
  
Connect to test
  
  
Identified by "test"
  
  
Using '(DESCRIPTION =
  
  
(ADDRESS_LIST =
  
  
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.101) (PORT = 1521 ))
  
  
)
  
  
(CONNECT_DATA =
  
  
(SERVICE_NAME = ora9i)
  
  
)
  
  
)';
 
 

Create public database link name

Connect to user name

Identified by "password"

 
 

  
  
Using '(DESCRIPTION =
  
  
(ADDRESS_LIST =
  
  
(ADDRESS = (PROTOCOL = TCP) (HOST = ADDRESS) (PORT = PORT ))
  
  
)
  
  
(CONNECT_DATA =
  
  
(SERVICE_NAME = SID)
  
  
)
  
  
)';
 
 

The above content describes Oracle cross-server operations, hoping to help you in this regard.

The above content describes Oracle cross-server operations, hoping to help you in this regard.