本文通过SQL操作演示了如何创建目录并使用EXPDP工具导出不同路径下的DUMP文件，然后利用IMPDP工具将其导入，证明了此过程的可行性与操作步骤。
-------->>>>from otn made by MacLean.liu
SQL> create directory dir1 as 'D:\dir1';
<wbr><br> Directory created.<br><wbr><br> SQL> create directory dir2 as 'D:\dir2';<br><wbr><br> Directory created.<br><wbr><br> SQL><br> SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production<br> With the Partitioning, OLAP, Data Mining and Real Application Testing options<br><wbr><br><wbr><br><wbr><br> C:\Users\ML>expdp system/oracle<wbr> dumpfile=dir1:1.dmp,dir2:2.dmp<wbr> schemas=maclean filesize=4M<br><wbr><br> Export: Release 11.2.0.3.0 - Production on Wed Oct 24 15:22:32 2012<br><wbr><br> Copyright (c) 1982, 2011, Oracle and/or its affiliates.<wbr> All rights reserved.<br><wbr><br> Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production<br> With the Partitioning, OLAP, Data Mining and Real Application Testing options<br> Starting "SYSTEM"."SYS_EXPORT_SCHEMA_02":<wbr> system/******** dumpfile=dir1:1.dmp,dir2:2.dmp schemas=maclean filesize=4M<br> Estimate in progress using BLOCKS method...<br> Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA<br> Total estimation using BLOCKS method: 9 MB<br> Processing object type SCHEMA_EXPORT/USER<br> Processing object type SCHEMA_EXPORT/SYSTEM_GRANT<br> Processing object type SCHEMA_EXPORT/ROLE_GRANT<br> Processing object type SCHEMA_EXPORT/DEFAULT_ROLE<br> Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA<br> Processing object type SCHEMA_EXPORT/TABLE/TABLE<br> . . exported "MACLEAN"."LLS"<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 7.289 MB<wbr><wbr> 75372 rows<br> Master table "SYSTEM"."SYS_EXPORT_SCHEMA_02" successfully loaded/unloaded<br> ******************************************************************************<br> Dump file set for SYSTEM.SYS_EXPORT_SCHEMA_02 is:<br><wbr> D:\DIR1\1.DMP<br><wbr> D:\DIR2\2.DMP<br> Job "SYSTEM"."SYS_EXPORT_SCHEMA_02" successfully completed at 15:23:12<br><br><br><br> C:\Users\ML>impdp system/oracle<wbr> dumpfile=dir1:1.dmp,dir2:2.dmp<wbr> remap_schema=maclean:scott<br><br> Import: Release 11.2.0.3.0 - Production on Wed Oct 24 15:23:54 2012<br><br> Copyright (c) 1982, 2011, Oracle and/or its affiliates.<wbr> All rights reserved.<br><br> Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production<br> With the Partitioning, OLAP, Data Mining and Real Application Testing options<br> Master table "SYSTEM"."SYS_IMPORT_FULL_01" successfully loaded/unloaded<br> Starting "SYSTEM"."SYS_IMPORT_FULL_01":<wbr> system/******** dumpfile=dir1:1.dmp,dir2:2.dmp remap_schema=maclean:scott<br> Processing object type SCHEMA_EXPORT/USER<br> ORA-31684: Object type USER:"SCOTT" already exists<br> Processing object type SCHEMA_EXPORT/SYSTEM_GRANT<br> Processing object type SCHEMA_EXPORT/ROLE_GRANT<br> Processing object type SCHEMA_EXPORT/DEFAULT_ROLE<br> Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA<br> Processing object type SCHEMA_EXPORT/TABLE/TABLE<br> Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA<br> . . imported "SCOTT"."LLS"<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 7.289 MB<wbr><wbr> 75372 rows<br> Job "SYSTEM"."SYS_IMPORT_FULL_01" completed with 1 error(s) at 15:24:04<br><br><br><br> impdp能否将不同路径下的dump文件同时导入<br><br> =》impdp 能否将不同 directory 下的dump文件导入？<br><br> 答案是 ： 可以, 见上述证明<br><br></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
SQL> create directory dir1 as 'D:\dir1';
<wbr><br> Directory created.<br><wbr><br> SQL> create directory dir2 as 'D:\dir2';<br><wbr><br> Directory created.<br><wbr><br> SQL><br> SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production<br> With the Partitioning, OLAP, Data Mining and Real Application Testing options<br><wbr><br><wbr><br><wbr><br> C:\Users\ML>expdp system/oracle<wbr> dumpfile=dir1:1.dmp,dir2:2.dmp<wbr> schemas=maclean filesize=4M<br><wbr><br> Export: Release 11.2.0.3.0 - Production on Wed Oct 24 15:22:32 2012<br><wbr><br> Copyright (c) 1982, 2011, Oracle and/or its affiliates.<wbr> All rights reserved.<br><wbr><br> Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production<br> With the Partitioning, OLAP, Data Mining and Real Application Testing options<br> Starting "SYSTEM"."SYS_EXPORT_SCHEMA_02":<wbr> system/******** dumpfile=dir1:1.dmp,dir2:2.dmp schemas=maclean filesize=4M<br> Estimate in progress using BLOCKS method...<br> Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA<br> Total estimation using BLOCKS method: 9 MB<br> Processing object type SCHEMA_EXPORT/USER<br> Processing object type SCHEMA_EXPORT/SYSTEM_GRANT<br> Processing object type SCHEMA_EXPORT/ROLE_GRANT<br> Processing object type SCHEMA_EXPORT/DEFAULT_ROLE<br> Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA<br> Processing object type SCHEMA_EXPORT/TABLE/TABLE<br> . . exported "MACLEAN"."LLS"<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 7.289 MB<wbr><wbr> 75372 rows<br> Master table "SYSTEM"."SYS_EXPORT_SCHEMA_02" successfully loaded/unloaded<br> ******************************************************************************<br> Dump file set for SYSTEM.SYS_EXPORT_SCHEMA_02 is:<br><wbr> D:\DIR1\1.DMP<br><wbr> D:\DIR2\2.DMP<br> Job "SYSTEM"."SYS_EXPORT_SCHEMA_02" successfully completed at 15:23:12<br><br><br><br> C:\Users\ML>impdp system/oracle<wbr> dumpfile=dir1:1.dmp,dir2:2.dmp<wbr> remap_schema=maclean:scott<br><br> Import: Release 11.2.0.3.0 - Production on Wed Oct 24 15:23:54 2012<br><br> Copyright (c) 1982, 2011, Oracle and/or its affiliates.<wbr> All rights reserved.<br><br> Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production<br> With the Partitioning, OLAP, Data Mining and Real Application Testing options<br> Master table "SYSTEM"."SYS_IMPORT_FULL_01" successfully loaded/unloaded<br> Starting "SYSTEM"."SYS_IMPORT_FULL_01":<wbr> system/******** dumpfile=dir1:1.dmp,dir2:2.dmp remap_schema=maclean:scott<br> Processing object type SCHEMA_EXPORT/USER<br> ORA-31684: Object type USER:"SCOTT" already exists<br> Processing object type SCHEMA_EXPORT/SYSTEM_GRANT<br> Processing object type SCHEMA_EXPORT/ROLE_GRANT<br> Processing object type SCHEMA_EXPORT/DEFAULT_ROLE<br> Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA<br> Processing object type SCHEMA_EXPORT/TABLE/TABLE<br> Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA<br> . . imported "SCOTT"."LLS"<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> 7.289 MB<wbr><wbr> 75372 rows<br> Job "SYSTEM"."SYS_IMPORT_FULL_01" completed with 1 error(s) at 15:24:04<br><br><br><br> impdp能否将不同路径下的dump文件同时导入<br><br> =》impdp 能否将不同 directory 下的dump文件导入？<br><br> 答案是 ： 可以, 见上述证明<br><br></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>
扫一扫
633
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
