datapump

参考文章:

http://www.linuxdiyf.com/viewarticle.php?id=22671

demo:使用impdp + network_link 进行不落地式的导入操作.

参考文章:http://www.jb51.net/article/32079.htm

注意:下面的语句是在目标数据库中执行的.

11203ora-> impdp user01/user01 network_link=new_dmp_link logfile=dmp_dir:user01.log  remap_schema=user01:target:user01 remap_tablespace=users:target:users

Import: Release 11.2.0.3.0 - Production on Wed Jul 31 23:02:08 2013

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

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
FLASHBACK automatically enabled to preserve database integrity.
Starting "USER01"."SYS_IMPORT_SCHEMA_01":  user01/******** network_link=new_dmp_link logfile=dmp_dir:user01.log remap_schema=user01:target:user01 remap_tablespace=users:target:users 
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 64 KB
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TABLE/TABLE
. . imported "USER01"."USER01_TAB_01"                         1 rows
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Job "USER01"."SYS_IMPORT_SCHEMA_01" successfully completed at 23:02:53

11203ora->

执行导入结果

11203ora-> impdp user01/user01 network_link=new_dmp_link logfile=dmp_dir:user01.log  remap_schema=user01:user01 tables=user01_tab_02 remap_tablespace=users:users

Import: Release 11.2.0.3.0 - Production on Wed Jul 31 23:07:02 2013

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

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "USER01"."SYS_IMPORT_TABLE_01":  user01/******** network_link=new_dmp_link logfile=dmp_dir:user01.log remap_schema=user01:user01 tables=user01_tab_02 remap_tablespace=users:users 
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 64 KB
Processing object type TABLE_EXPORT/TABLE/TABLE
. . imported "USER01"."USER01_TAB_02"                         1 rows
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Job "USER01"."SYS_IMPORT_TABLE_01" successfully completed at 23:07:16

11203ora->

指定表名称导入;