通过dblink impdp导入

实验:

源数据库:10.5.129.160 dwhtest

需要导入的数据库:10.5.129.130 dwhtest

在10.5.129.130上创建DBLINK
SQL> create  public database link DBL_DWHTEST connect to dwf identified by dwf using 'dwhtest160';

Database link created.

SQL> select * from dual@DBL_DWHTEST;

D
-
X
在10.5.129.130上执行impdp
[oracle@dwhtest admin]$ impdp dwf/dwf  NETWORK_LINK=DBL_DWHTEST schemas=dwf

Import: Release 11.2.0.4.0 - Production on Wed Dec 18 10:15:23 2013

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

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "DWF"."SYS_IMPORT_SCHEMA_01":  dwf/******** NETWORK_LINK=DBL_DWHTEST schemas=dwf
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 260.9 GB
Processing object type SCHEMA_EXPORT/USER
ORA-31684: Object type USER:"DWF" already exists
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/TABLESPACE_QUOTA
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TABLE/TABLE