Two Methods for oracle to connect to a remote database to export data

How can I export data from a remote database through oracle? The following describes how to connect to a remote database to export data from oracle for your reference.

How to export data from a remote database using oracle.

Run the following SQL statement to create a database link:

 
 

  
  
Create database link test_link -- link name
  
  
Connect to username identified by password
  
  
Using '(DESCRIPTION =
  
  
(ADDRESS_LIST =
  
  
(ADDRESS = (PROTOCOL = TCP) (HOST = database server ADDRESS) (PORT = PORT) -- default PORT 1521
  
  
)
  
  
(CONNECT_DATA =
  
  
(SERVICE_NAME = ctaiscs) -- we recommend that you use the global database name after oracle9i.
  
  
)
  
  
)'
  
  
 
  
  
SERVICE_NAME = ctais, using SID = database SID
 
 

OK. Now you can query the remote database.

 
 

  
  
Select *  from  employee@test_link 
 
 

Method 2

A) configure the service name

Open C: \ Oracle \ ora92 \ network \ admin \ tnsnames. ora and add the service name.

 
 

  
  
Service name =
  
  
(DESCRIPTION =
  
  
(ADDRESS_LIST =
  
  
(ADDRESS = (PROTOCOL = TCP) (HOST = 10.6.30.12) (PORT = 1521 ))
  
  
)
  
  
(CONNECT_DATA =
  
  
(SERVICE_NAME = Global Database Name) -- Also available SID = database SID
  
  
)
  
  
)
 
 

B) Create a database connection

 
 

  
  
Create database link test_link -- link name
  
  
 
  
  
Connect to username identified by password
  
  
 
  
  
Using 'service name'
 
 

The following processing method is the same:

Oracle RMAN backup Optimization

Oracle EXP/IMP backup Overview

Oracle backup using RMAN

How to Implement ORACLE backup

Oracle backup command to use instances