Wednesday, 13 March 2013

Using network link to import data in Oracle

Using network link to import data in Oracle

1.Create database link ,in destination database, pointing to source database from where you want import the data as below.

In our case:
Source Schema =dwadm
Destination Schema=zz_dwadm

SQL> conn zz_dwadm/zz_dwadm
SQL> create database link QA1DB_TO_DEVDB connect to dwadm identified by dwadm using 'QA1DB';

Database link created.

SQL> exit
Disconnected from Oracle

2.Import the table TEST_TABLE from dwadm into zz_dwadm using below command

impdp directory=dump_dir network_link=QA1DB_TO_DEVDB tables=dwadm.TEST_TABLE logfile=impdp.log remap_schema=dwadm:zz_dwadm

Import: Release - Production on Wed Mar 13 09:40:30 2013

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

Username: zz_dwadm/zz_dwadm

Connected to: Oracle Database 11g Enterprise Edition Release - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

No comments:

Post a Comment