加载中…
个人资料
Lixora
Lixora
  • 博客等级:
  • 博客积分:0
  • 博客访问:199,344
  • 关注人气:18
  • 获赠金笔:0支
  • 赠出金笔:0支
  • 荣誉徽章:
正文 字体大小:

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

(2012-10-24 17:34:05)
标签:

it

分类: 学习笔记
-------->>>>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文件导入?

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

0

阅读 收藏 喜欢 打印举报/Report
  

新浪BLOG意见反馈留言板 欢迎批评指正

新浪简介 | About Sina | 广告服务 | 联系我们 | 招聘信息 | 网站律师 | SINA English | 产品答疑

新浪公司 版权所有