HOW TO EXPORT DATA FROM REMOTE DATABASE USING DATAPUMP.

HOW TO EXPORT DATA FROM REMOTE DATABASE USING DATAPUMP.

In this article, we will see how to export data from remote database and import in source database.

Source Database :

iP address : 192.168.0.51

Instance Name : primary

Remote Database : 

iP address : 192.168.0.61

Instance Name : orcl

Steps to implement :

1.Networking b/w hosts (Both Source and Remote servers should ping each other)

2.Create & start listener.ora  in Remote server.

3.create  tnsnames.ora in Source server .

4.In source database choose one user and create database link.

5.check database link by selecting data

6.In source server perform EXPDP operation using network_link

7.Import data into source database using dumpfile

Now implement above steps :

Step 1 :

Networking b/w hosts (Both Source and Remote servers should ping each other)

Remote Server :

Step 2 :

Create & start listener.ora  in Remote server.

Start listener

Source Server :

Step 3 :

create  tnsnames.ora in Source server .

Step 4 :

In source database choose one user and create database link.

Create database link

Step 5 :

Selecting  the data using database link

Yes , The data is selecting through dblink from remote database.

Step 6 :

Now perform export operation by creating PAR file.

Create PAR file

Now export the data

Execution :

Check Dumpfile and Logfiles.

Step 7 :

Perform import operation to source database using dumpfile

Create Parfile

Perform import operation

In above import operation , if tables already exists it will truncate those tables and then data will be imported.

Performing Import without dumpfile using network_link 

On Source database :

Perform import operation use same parfile

import operation

In above import operation , if tables already exists it will truncate those tables and then data will be imported without generating dumpfiles and logfiles

 

 

Thank you……

Note: Please test scripts in Non Prod before trying in Production.
1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...

Add Comment