温馨提示×

温馨提示×

您好，登录后才能下订单哦！

密码登录×
登录注册×
获取短信验证码
其他方式登录
点击 登录注册 即表示同意《亿速云用户服务条款》
登 录 注册有礼
云服务器 香港服务器 高防服务器
最新更新 网站标签 地图导航
产品

数据泵导出文件更换名称，对导入操作无影响

发布时间：2020-08-11 18:18:03 来源：ITPUB博客 阅读：262 作者：刘锡亚 栏目：关系型数据库
问题描述： expdp 导出 dmp文件 ，但是导出操作时，dmp文件命名有误。 mv将导出后的dmp文件重命名。这样对 impdp 操作会有什么影响呢？
结论：  只要命令敲对，文件名写正确，impdp操作不受影响



一、模拟开始
      scott用户下的表

点击(此处)折叠或打开

  1. SQL> conn scott/tiger
  2. Connected.
  3. SQL>
  4. SQL> select count(*) from tab;

  6.   COUNT(*)
  7. ----------
  8.      4

  10. SQL> select * from tab;

  12. TNAME             TABTYPE    CLUSTERID
  13. ------------------------------ ------- ----------
  14. BONUS             TABLE
  15. DEPT             TABLE
  16. EMP             TABLE
  17. SALGRADE         TABLE
  新建用户liuyaya下的表

点击(此处)折叠或打开

  1. SQL> conn / as sysdba
  2. Connected.
  3. SQL>
  4. SQL>
  5. SQL> create user liuyaya identified by oracle account unlock;


  8. User created.

  10. SQL> SQL>
  11. SQL>
  12. SQL>
  13. SQL> grant connect,resource to liuyaya;

  15. Grant succeeded.

  17. SQL>
  18. SQL> conn liuyaya/oracle
  19. Connected.
  20. SQL> select count(1) from tab;

  22.   COUNT(1)
  23. ----------
  24.      0
   数据泵导出scott用户下的表

点击(此处)折叠或打开

  1. SQL> conn sys/oracle as sysdba
  2. Connected.
  3. SQL> create or replace directory expdp_dir_scott01 as '/soft';

  5. Directory created.

  7. SQL> grant read,write on directory expdp_dir_scott01 to scott;

  9. Grant succeeded.

  11. SQL> exit


点击(此处)折叠或打开

  1. [oracle@redhat6 ~]$ expdp scott/tiger directory=expdp_dir_scott01 schemas=scott datafile=scott01.dmp logfile=scott01.log parallel=2;
  2. LRM-00101: unknown parameter name 'datafile'

  4. [oracle@redhat6 ~]$ expdp scott/tiger directory=expdp_dir_scott01 schemas=scott dumpfile=scott01.dmp logfile=scott01.log parallel=2;

  6. Export: Release 11.2.0.4.0 - Production on Thu Jun 21 19:15:52 2018

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

  10. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
  11. With the Partitioning, OLAP, Data Mining and Real Application Testing options
  12. Starting "SCOTT"."SYS_EXPORT_SCHEMA_01": scott/******** directory=expdp_dir_scott01 schemas=scott dumpfile=scott01.dmp logfile=scott01.log parallel=2
  13. Estimate in progress using BLOCKS method...
  14. Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
  15. Total estimation using BLOCKS method: 192 KB
  16. . . exported "SCOTT"."DEPT" 5.929 KB 4 rows
  17. Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
  18. . . exported "SCOTT"."EMP" 8.562 KB 14 rows
  19. . . exported "SCOTT"."SALGRADE" 5.859 KB 5 rows
  20. . . exported "SCOTT"."BONUS" 0 KB 0 rows
  21. Processing object type SCHEMA_EXPORT/TABLE/TABLE
  22. Processing object type SCHEMA_EXPORT/TABLE/COMMENT
  23. Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
  24. Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
  25. Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
  26. Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
  27. Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
  28. Master table "SCOTT"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
  29. ******************************************************************************
  30. Dump file set for SCOTT.SYS_EXPORT_SCHEMA_01 is:
  31.   /soft/scott01.dmp
  32. Job "SCOTT"."SYS_EXPORT_SCHEMA_01" successfully completed at Thu Jun 21 19:16:13 2018 elapsed 0 00:00:20
   修改dumpfile文件名


点击(此处)折叠或打开

  1. [oracle@redhat6 ~]$ cd /soft
  2. [oracle@redhat6 soft]$ ls
  3. database scott01.dmp scott01.log zjgd_back
  4. [oracle@redhat6 soft]$ mv scott01.dmp liuyaya.dmp
  5. [oracle@redhat6 soft]$ ls
  6. database liuyaya.dmp scott01.log zjgd_back

导入到新建用户liuyaya

点击(此处)折叠或打开

  1. [oracle@redhat6 soft]$ impdp \'/ as sysdba\' directory=expdp_dir_scott01 dumpfile=liuyaya.dmp remap_schema=scott:liuyaya logfile=liuyaya.log parallel=2

  3. Import: Release 11.2.0.4.0 - Production on Thu Jun 21 20:18:01 2018

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

  7. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
  8. With the Partitioning, OLAP, Data Mining and Real Application Testing options
  9. Master table "SYS"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
  10. Starting "SYS"."SYS_IMPORT_FULL_01": "/******** AS SYSDBA" directory=expdp_dir_scott01 dumpfile=liuyaya.dmp remap_schema=scott:liuyaya logfile=liuyaya.log parallel=2
  11. Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
  12. Processing object type SCHEMA_EXPORT/TABLE/TABLE
  13. Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
  14. . . imported "LIUYAYA"."DEPT" 5.929 KB 4 rows
  15. . . imported "LIUYAYA"."EMP" 8.562 KB 14 rows
  16. . . imported "LIUYAYA"."SALGRADE" 5.859 KB 5 rows
  17. . . imported "LIUYAYA"."BONUS" 0 KB 0 rows
  18. Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
  19. Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
  20. Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
  21. Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
  22. Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
  23. Job "SYS"."SYS_IMPORT_FULL_01" successfully completed at Thu Jun 21 20:18:05 2018 elapsed 0 00:00:02

  25. [oracle@redhat6 soft]$ sqlplus liuyaya/oracle

  27. SQL*Plus: Release 11.2.0.4.0 Production on Thu Jun 21 20:18:18 2018

  29. Copyright (c) 1982, 2013, Oracle. All rights reserved.


  32. Connected to:
  33. Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
  34. With the Partitioning, OLAP, Data Mining and Real Application Testing options

  36. SQL> select * from tab;

  38. TNAME             TABTYPE    CLUSTERID
  39. ------------------------------ ------- ----------
  40. BONUS             TABLE
  41. DEPT             TABLE
  42. EMP             TABLE
  43. SALGRADE         TABLE

二、 总结

将改了名字的dmp文件顺利导入到其他schema下，证明
    
数据库导出文件可以改名字，对导入操作无影响






向AI问一下细节
推荐阅读：
  1. 10g 数据泵导出，12c数据泵导入
  2. MySQL自身对性能的影响

免责声明：本站发布的内容（图片、视频和文字）以原创、转载和分享为主，文章观点不代表本网站立场，如果涉及侵权请联系站长邮箱：is@yisu.com进行举报，并提供相关证据，一经查实，将立刻删除涉嫌侵权内容。

名称 更换 导入

猜你喜欢

最新资讯
相关推荐

相关标签

蓝桥 器件 归类 等待 功丨 nik 检索 combobox 倒在 法则 slow rownum oracle11gr2 效验 基本结构 鸿蒙 从头到尾 手记 谁在 netstat
AI
助
手
产品服务
地区划分
专题活动
帮助支持
关于我们
售后咨询
7*24小时在线电话：400-100-2938
7*24小时在线 QQ：800811969
关注亿速云

亿速云公众号

手机网站二维码

Copyright © Yisu Cloud Ltd. All Rights Reserved. 2018 版权所有

广州亿速云计算有限公司粤ICP备17096448号-1 粤公网安备 44010402001142号增值电信业务经营许可证编号：B1-20181529