来源：蜘蛛抓取(WebSpider)
时间：2017-09-12 07:46
标签：
oracle 数据库泵
详解oracle的导入和导出(数据泵)_百度文库
两大类热门资源免费畅读
续费一年阅读会员，立省24元！
评价文档：
详解oracle的导入和导出(数据泵)
&&oracle的导入和导出--数据泵
大小：153.50KB
登录百度文库，专享文档复制特权，财富值每天免费拿！
你可能喜欢 最近用到Oracle导出导入数据，在网上看了别人的一些文章，总结如下：
Oracle导出导出有两中方式：一、利用exp imp导出导入；二、利用Oracel数据泵expdp impdp导出导入。
一、利用exp imp导出导入
exp imp 语法如下：
1) 将数据库orcl完全导出
exp system/manager@orcl file=d:\orcl_bak.dmp full=y
2) 将数据库中system用户的表导出
exp system/manager@orcl file=d:\system_bak.dmp owner=system
3) 将数据库中表table1，table2导出
exp system/manager@orcl file=d:\table_bak.dmp tables=(table1,table2)
4) 将数据库中的表customer中的字段mobile以"139"开头的数据导出
exp system/manager@orcl file=d:\mobile_bak.dmp tables=customer query=\"where mobile like '139%' \"
1) 将备份文件bak.dmp导出数据库
imp system/manager@orcl file=d:\bak.dmp
如果数据表中表已经存在，会提示错误，在后面加上ignore=y就可以了。
2) 将备份文件bak.dmp中的表table1导入
imp system/manager@orcl file=d:\bak.dmp tables=(table1)
exp imp导出导入数据方式的好处是只要你本地安装了Oracle客户端，你就可以将服务器中的数据导出到你本地计算机。同样也可以将dmp文件从你本地导入到服务器数据库中。但是这种方式在Oracle11g版本中会出现一个问题：不能导出空表。Oracle11g新增了一个参数deferred_segment_creation，含义是段延迟创建，默认是true。当你新建了一张表，并且没用向其中插入数据时，这个表不会立即分配segment。
解决办法：
1、设置deferred_segment_creation参数为false后，无论是空表，还是非空表，都分配segment。
在sqlplus中，执行如下命令：
SQL&alter system set deferred_segment_creation=
查看：
SQL&show parameter deferred_segment_
该值设置后，只对后面新增的表起作用，对之前建立的空表不起作用，并且注意要重启数据库让参数生效。
2、使用 ALLOCATE EXTEN
使用 ALLOCATE EXTEN可以为数据库对象分配Extent，语法如下：
alter table table_name allocate extent
构建对空表分配空间的SQL命令：
SQL&select 'alter table '||table_name||'' from user_tables where num_rows=0
批量生成要修改的语句。
然后执行这些修改语句，对所有空表分配空间。
此时用exp命令，可将包括空表在内的所有表导出。
二、利用expdp impdp导出导入
在Oracle10g中exp imp被重新设计为Oracle Data Pump（保留了原有的 exp imp工具）
数据泵与传统导出导入的区别;
1) exp和imp是客户端工具，他们既可以在客户端使用，也可以在服务端使用。
2) expdp和impdp是服务端工具，只能在Oracle服务端使用。
3) imp只适用于exp导出文件，impdp只适用于expdp导出文件。
expdp导出数据：
1、为输出路径建立一个数据库的directory对象。
create or replace directory dumpdir as 'd:\';
可以通过：select * from dba_查看。
2、给将要进行数据导出的用户授权访问。
grant read,write on directory dumpdir to test_
3、将数据导出
expdp test_expdp/test_expdp directory=dumpdir dumpfile=test_expdp_bak.dmp logfile=test_expdp_bak.log schemas=test_expdp
注意：这句话在cmd窗口中运行，并且最后不要加分号，否则会提示错误。因为这句话是操作系统命令而不是SQL。
impdp导入数据：
1、给将要进行数据导入的用户授权访问。
grant read,write on directory dumpdir to test_
2、将数据导入
impdp test_impdp/impdp directory=dumpdir dumpfile=test_expdp_bak.dmp remap_schema=test_expdp:test_impdp
最后：这些内容是我在查找资料时找到，由于比较杂乱，现在稍作整理，方便以后查阅。同时，如果能给需要的人提供一些帮助，那就再好不过了。
阅读(...) 评论()Oracle使用数据泵 (expdp/impdp)实施迁移_数据库技术_Linux公社-Linux系统门户网站
你好，游客
Oracle使用数据泵 (expdp/impdp)实施迁移
来源：Linux社区&
作者：seiang
实验环境：
1、导出环境：6.4+ 11.2.0.4.0，利用数据库自带的scott示例用户进行试验测试。
Directory：wjq && /tmp/seiang_wjq
2、导入环境：7.1+Oracle 12.2.0.1.0 & Oracle12c默认没有scott用户
Directory：imp_wjq && /tmp/imp_comsys
一、导出数据：
特别注意：如果后续要导入的数据库版本低，所有导出命令就需要在后面加一个version=指定版本。例如11g -& 10g，假设10g具体版本为10.2.0.1，那么就加一个版本的参数version=10.2.0.1。
1. 首先需要创建Directory
注意：目录在系统上需要真实存在（mkdir /tmp/seiang_wjq），且有访问的权限。
2. 使用expdp导出用户数据
2.1 只导出scott用户的元数据，且不包含统计信息；
[oracle@seiangwjq ~]$ expdp system directory=wjq schemas=scott content=metadata_onlyexclude=statistics dumpfile=scott_meta.dmp logfile=scott_meta.log
Export: Release 11.2.0.4.0 - Production on Mon Apr 24 14:17:16 2017
Copyright (c) , Oracle and/or its affiliates. &All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "SYSTEM"."SYS_EXPORT_SCHEMA_01": &system/******** directory=wjq schemas=scott content=metadata_only exclude=statistics dumpfile=scott_meta.dmp logfile=scott_meta.log
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
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Master table "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYSTEM.SYS_EXPORT_SCHEMA_01 is:
/tmp/seiang_wjq/scott_meta.dmp
Job "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully completed at Mon Apr 24 14:17:48 2017 elapsed 0 00:00:21
2.2 只导出scott用户的数据；
[oracle@seiangwjq ~]$ expdp system directory=wjq schemas=scott content=data_only dumpfile=scott_data.dmp logfile=scott_data.log
Export: Release 11.2.0.4.0 - Production on Mon Apr 24 14:22:36 2017
Copyright (c) , Oracle and/or its affiliates. &All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "SYSTEM"."SYS_EXPORT_SCHEMA_01": &system/******** directory=wjq schemas=scott content=data_only dumpfile=scott_data.dmp logfile=scott_data.log
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 192 KB
. . exported "SCOTT"."DEPT" & & & & & & & & & & & & & & &5.929 KB & & & 4 rows
. . exported "SCOTT"."EMP" & & & & & & & & & & & & & & & 8.562 KB & & &14 rows
. . exported "SCOTT"."SALGRADE" & & & & & & & & & & & & &5.859 KB & & & 5 rows
. . exported "SCOTT"."BONUS" & & & & & & & & & & & & & & & & 0 KB & & & 0 rows
Master table "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYSTEM.SYS_EXPORT_SCHEMA_01 is:
/tmp/seiang_wjq/scott_data.dmp
Job "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully completed at Mon Apr 24 14:22:47 2017 elapsed 0 00:00:06
2.3 只导出scott用户下的emp，dept表及数据；
[oracle@seiangwjq ~]$ expdp scott directory=wjq tables=emp,dept dumpfile=scott_emp_dept.dmp logfile=scott_emp_dept.log
Export: Release 11.2.0.4.0 - Production on Mon Apr 24 14:25:37 2017
Copyright (c) , Oracle and/or its affiliates. &All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
ORA-39087: directory name WJQ is invalid
这里如果用scott用户导出，需要注意scott用户对于directory的权限问题：需要dba用户赋予scott用户read,write目录的权限。
[oracle@seiangwjq ~]$ expdp scott directory=wjq tables=emp,dept dumpfile=scott_emp_dept.dmplogfile=scott_emp_dept.log
Export: Release 11.2.0.4.0 - Production on Mon Apr 24 14:28:18 2017
Copyright (c) , Oracle and/or its affiliates.& All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real ApplicationTesting options
Starting "SCOTT"."SYS_EXPORT_TABLE_01":& scott/******** directory=wjq tables=emp,deptdumpfile=scott_emp_dept.dmp logfile=scott_emp_dept.log
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 128 KB
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
. . exported "SCOTT"."DEPT"& & & & & & & & & & & & & & & 5.929 KB& & & 4 rows
. . exported "SCOTT"."EMP"& & & & & & & & & & & & & & & 8.562 KB& & & 14 rows
Master table "SCOTT"."SYS_EXPORT_TABLE_01"successfully loaded/unloaded
******************************************************************************
Dump file set for SCOTT.SYS_EXPORT_TABLE_01 is:
& /tmp/seiang_wjq/scott_emp_dept.dmp
Job "SCOTT"."SYS_EXPORT_TABLE_01" successfullycompleted at Mon Apr 24 14:28:35 2017 elapsed 0 00:00:09
2.4 只导出scott用户下的emp，dept表结构；
[oracle@seiangwjq ~]$ expdp scott directory=wjq tables=emp,dept content=metadata_onlydumpfile=scott_emp_dept_meta.dmp logfile=scott_emp_dept_meta.log
Export: Release 11.2.0.4.0 - Production on Mon Apr 24 14:34:07 2017
Copyright (c) , Oracle and/or its affiliates.& All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real ApplicationTesting options
Starting "SCOTT"."SYS_EXPORT_TABLE_01":& scott/******** directory=wjq tables=emp,deptcontent=metadata_only dumpfile=scott_emp_dept_meta.dmplogfile=scott_emp_dept_meta.log
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Master table "SCOTT"."SYS_EXPORT_TABLE_01"successfully loaded/unloaded
******************************************************************************
Dump file set for SCOTT.SYS_EXPORT_TABLE_01 is:
& /tmp/seiang_wjq/scott_emp_dept_meta.dmp
Job "SCOTT"."SYS_EXPORT_TABLE_01" successfullycompleted at Mon Apr 24 14:34:21 2017 elapsed 0 00:00:08
2.5 导出scott用户下所有的内容；
[oracle@seiangwjq ~]$ expdp system directory=wjq schemas=scott dumpfile=scott_all.dmplogfile=scott_all.log
Export: Release 11.2.0.4.0 - Production on Mon Apr 24 14:38:10 2017
Copyright (c) , Oracle and/or its affiliates.& All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real ApplicationTesting options
Starting "SYSTEM"."SYS_EXPORT_SCHEMA_01":& system/******** directory=wjq schemas=scottdumpfile=scott_all.dmp logfile=scott_all.log
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 192 KB
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
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
. . exported "SCOTT"."DEPT"& & & & & & & & & & & & & & &5.929 KB& & & 4 rows
. . exported "SCOTT"."EMP"& & & & & & & & & & & & & & & 8.562 KB& & & 14 rows
. . exported "SCOTT"."SALGRADE"& & & & & & & & & & & & & 5.859 KB& & & 5 rows
. . exported "SCOTT"."BONUS"& & & & & & & & & & & & & & & & 0 KB& & & 0 rows
Master table "SYSTEM"."SYS_EXPORT_SCHEMA_01"successfully loaded/unloaded
******************************************************************************
Dump file set for SYSTEM.SYS_EXPORT_SCHEMA_01 is:
& /tmp/seiang_wjq/scott_all.dmp
Job "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfullycompleted at Mon Apr 24 14:38:30 2017 elapsed 0 00:00:16
2.6 并行导出scott用户下所有的内容；
[oracle@seiangwjq ~]$ expdp system directory=wjq schemas=scott dumpfile=scott_all%U.dmplogfile=scott_all.log parallel=2&
Export: Release 11.2.0.4.0 - Production on Mon Apr 24 14:44:04 2017
Copyright (c) , Oracle and/or its affiliates.& All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real ApplicationTesting options
Starting "SYSTEM"."SYS_EXPORT_SCHEMA_01":& system/******** directory=wjq schemas=scottdumpfile=scott_all%U.dmp logfile=scott_all.log parallel=2
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 192 KB
Processing object type SCHEMA_EXPORT/USER
. . exported "SCOTT"."DEPT"& & & & & & & & & & & & & & & 5.929 KB& & & 4 rows
. . exported "SCOTT"."EMP"& & & & & & & & & & & & & & & &8.562 KB& & & 14 rows
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
. . exported "SCOTT"."SALGRADE"& & & & & & & & & & & & & 5.859 KB& & & 5 rows
. . exported "SCOTT"."BONUS"& & & & & & & & & & & & & & & & &0 KB& & & 0 rows
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/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Master table "SYSTEM"."SYS_EXPORT_SCHEMA_01"successfully loaded/unloaded
******************************************************************************
Dump file set for SYSTEM.SYS_EXPORT_SCHEMA_01 is:
& /tmp/seiang_wjq/scott_all01.dmp
& /tmp/seiang_wjq/scott_all02.dmp
Job "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfullycompleted at Mon Apr 24 14:44:27 2017 elapsed 0 00:00:15
3. 查询当前用户用到的表空间
二、导入数据
导入准备：将刚才从11g数据库导出的内容通过scp发送给12c
1. 首先需要创建Directory
2. 使用impdp导入用户数据
2.1 导入scott用户的元数据，且不包含统计信息；
[oracle@seiang ~]$ impdp system directory=imp_wjq dumpfile=scott_meta.dmplogfile=imp_scott_meta.log
Import: Release 12.2.0.1.0 - Production on Mon Apr 24 15:26:30 2017
Copyright (c) , Oracle and/or its affiliates.& All rights reserved.
Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0- 64bit Production
Master table "SYSTEM"."SYS_IMPORT_FULL_01"successfully loaded/unloaded
Starting "SYSTEM"."SYS_IMPORT_FULL_01":& system/******** directory=imp_wjqdumpfile=scott_meta.dmp logfile=imp_scott_meta.log
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
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Job "SYSTEM"."SYS_IMPORT_FULL_01" successfullycompleted at Mon Apr 24 15:27:15 2017 elapsed 0 00:00:20
2.2 导入scott用户的数据；
只有在2.1导入元数据后才可以导入数据。
[oracle@seiang ~]$ impdp system directory=imp_wjq dumpfile=scott_data.dmplogfile=imp_scott_data.log
Import: Release 12.2.0.1.0 - Production on Mon Apr 24 15:29:27 2017
Copyright (c) , Oracle and/or its affiliates.& All rights reserved.
Connected to: Oracle Database 12c Enterprise Edition Release12.2.0.1.0 - 64bit Production
Master table "SYSTEM"."SYS_IMPORT_FULL_01"successfully loaded/unloaded
Starting "SYSTEM"."SYS_IMPORT_FULL_01":& system/******** directory=imp_wjqdumpfile=scott_data.dmp logfile=imp_scott_data.log
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
. . imported "SCOTT"."DEPT"& & & & & & & & & & & & & & & 5.929 KB& & & 4 rows
. . imported "SCOTT"."EMP"& & & & & & & & & & & & & & & 8.562 KB& & & 14 rows
. . imported "SCOTT"."SALGRADE"& & & & & & & & & & & & & 5.859 KB& & & 5 rows
. . imported "SCOTT"."BONUS"& & & & & & & & & & & & & & & & 0 KB& & & 0 rows
Job "SYSTEM"."SYS_IMPORT_FULL_01" successfullycompleted at Mon Apr 24 15:29:44 2017 elapsed 0 00:00:12
2.3 只导入scott用户下的emp表及数据；
[oracle@seiang ~]$ impdp scott directory=imp_wjq tables=empdumpfile=scott_emp_dept.dmp logfile=imp_scott_emp.log
Import: Release 12.2.0.1.0 - Production on Mon Apr 24 15:40:56 2017
Copyright (c) , Oracle and/or its affiliates.& All rights reserved.
Connected to: Oracle Database 12c Enterprise Edition Release12.2.0.1.0 - 64bit Production
ORA-39002:invalid operation
ORA-39070:Unable to open the log file.
ORA-39087:directory name IMP_WJQ is invalid
因为在导入的时候没有给imp_wjq目录赋予read和write的权限，所以会出现上面的错误，下面就给imp_wjq目录授权：
[oracle@seiang ~]$ impdp scott directory=imp_wjq tables=emp dumpfile=scott_emp_dept.dmplogfile=imp_scott_emp.log
Import: Release 12.2.0.1.0 - Production on Mon Apr 24 15:45:03 2017
Copyright (c) , Oracle and/or its affiliates.& All rights reserved.
Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0- 64bit Production
Master table "SCOTT"."SYS_IMPORT_TABLE_01"successfully loaded/unloaded
Starting "SCOTT"."SYS_IMPORT_TABLE_01":& scott/******** directory=imp_wjq tables=empdumpfile=scott_emp_dept.dmp logfile=imp_scott_emp.log
Processing object type TABLE_EXPORT/TABLE/TABLE
ORA-39151:Table "SCOTT"."EMP" exists. All dependent metadata and datawill be skipped due to table_exists_action of skip
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Job "SCOTT"."SYS_IMPORT_TABLE_01" completed with1 error(s) at Mon Apr 24 15:45:13 2017 elapsed 0 00:00:04
2.4 只导入scott用户下的emp,dept表结构；
由于之前2.1、2.2、2.3导入的执行，所有的表都已成功导入，为了接下来的实验，我们把scott用户下存在的表都删掉；
[oracle@seiang ~]$ impdp scott directory=imp_wjq tables=emp,dept dumpfile=scott_emp_dept_meta.dmplogfile=imp_scott_emp_dept_meta.log
Import: Release 12.2.0.1.0 - Production on Mon Apr 24 15:59:16 2017
Copyright (c) , Oracle and/or its affiliates.& All rights reserved.
Connected to: Oracle Database 12c Enterprise Edition Release12.2.0.1.0 - 64bit Production
Master table "SCOTT"."SYS_IMPORT_TABLE_01"successfully loaded/unloaded
Starting "SCOTT"."SYS_IMPORT_TABLE_01":& scott/******** directory=imp_wjqtables=emp,dept dumpfile=scott_emp_dept_meta.dmplogfile=imp_scott_emp_dept_meta.log
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Job "SCOTT"."SYS_IMPORT_TABLE_01" successfullycompleted at Mon Apr 24 15:59:22 2017 elapsed 0 00:00:02
由于导出就是emp,dept两张表，所以也可以不指定tables，以下两种写法在这里都是可以的：
[oracle@seiang ~]$ impdp scott directory=imp_wjqdumpfile=scott_emp_dept_meta.dmp logfile=imp_scott_emp_dept_meta.log
[oracle@seiang ~]$ impdp scott directory=imp_wjqdumpfile=scott_emp_dept_meta.dmp logfile=imp_scott_emp_dept_meta.log full=y
更多详情见请继续阅读下一页的精彩内容：
相关资讯 & & &
& (05月05日)
& (09/05/:14)
& (06/22/:09)
& (04/09/:21)
& (07/19/:47)
& (05/23/:38)
同意评论声明
发表
尊重网上道德，遵守中华人民共和国的各项有关法律法规
承担一切因您的行为而直接或间接导致的民事或刑事法律责任
本站管理人员有权保留或删除其管辖留言中的任意内容
本站有权在网站内转载或引用您的评论
参与本评论即表明您已经阅读并接受上述条款
