-------->>>>from otn made by MacLean.liu

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文件导入？

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