主题: impdp能否将不同路径下的dump文件同时导入-优快云博客

转载： https://cn.forums.oracle.com/forums/thread.jspa?messageID=10654213#10654213

impdp能否将不同路径下的dump文件同时导入
发布: 2012-10-23 下午7:53

使用expdp/impdp作prod-->dev同步，但是dump文件数目多且大(使用parallel导出/所有加起来才是一个整体)，只能放在dev server上的多个路径储存
现在问题是，impdp是否可以将不同路径下的dump文件一次性导入数据库，就像它们位于同一路径下的那样？
DB：10205
OS：HP-UX

帖子经 956503编辑过

Liu Maclean(刘相兵)

发贴数: 642
注册时间: 12-08-21

Re: impdp能否将不同路径下的dump文件同时导入
发布: 2012-10-24 上午12:25

回复： 956503

ask_maclean , oracle数据库官方中文技术论坛 , 甲骨文中国

SQL> create directory dir1 as 'D:\dir1';
 
Directory created.
 
SQL> create directory dir2 as 'D:\dir2';
 
Directory created.
 
SQL>
SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
 
 
 
C:\Users\ML>expdp system/oracle  dumpfile=dir1:1.dmp,dir2:2.dmp  schemas=maclean filesize=4M
 
Export: Release 11.2.0.3.0 - Production on Wed Oct 24 15:22:32 2012
 
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 "SYSTEM"."SYS_EXPORT_SCHEMA_02":  system/******** dumpfile=dir1:1.dmp,dir2:2.dmp schemas=maclean filesize=4M
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 9 MB
Processing object type SCHEMA_EXPORT/USER
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/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TABLE/TABLE
. . exported "MACLEAN"."LLS"                             7.289 MB   75372 rows
Master table "SYSTEM"."SYS_EXPORT_SCHEMA_02" successfully loaded/unloaded
******************************************************************************
Dump file set for SYSTEM.SYS_EXPORT_SCHEMA_02 is:
  D:\DIR1\1.DMP
  D:\DIR2\2.DMP
Job "SYSTEM"."SYS_EXPORT_SCHEMA_02" successfully completed at 15:23:12



C:\Users\ML>impdp system/oracle  dumpfile=dir1:1.dmp,dir2:2.dmp  remap_schema=maclean:scott

Import: Release 11.2.0.3.0 - Production on Wed Oct 24 15:23:54 2012

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
Master table "SYSTEM"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "SYSTEM"."SYS_IMPORT_FULL_01":  system/******** dumpfile=dir1:1.dmp,dir2:2.dmp remap_schema=maclean:scott
Processing object type SCHEMA_EXPORT/USER
ORA-31684: Object type USER:"SCOTT" 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/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
. . imported "SCOTT"."LLS"                               7.289 MB   75372 rows
Job "SYSTEM"."SYS_IMPORT_FULL_01" completed with 1 error(s) at 15:24:04

impdp能否将不同路径下的dump文件同时导入

=》impdp 能否将不同 directory 下的dump文件导入？

答案是　：可以, 见上述证明