impdp 将数据导入数据库中报错:ORA-39002: invalid operation ,ORA-39059: dump file set is incomplete 、ORA-39246: cannot locate master table within provided dump files
0
在用IMPDP执行导入操作时报没有该用户。 导入命令:impdp ts/ts DIRECTORY=tsdmp DUMPFILE=expdp.dmp REMAP_SCHEMA=bst:ts;
Connected to: Oracle Database 10g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
ORA-39002: invalid operation
ORA-39165: Schema XXX was not found.
Import: Release 11.2.0.3.0 - Production on Tue Jan 14 15:29:36 2014
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, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
ORA-39002: invalid operation
ORA-39059: dump file set is incomplete
ORA-39246: cannot locate master table within provided dump files
Connected to: Oracle Database 10g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
ORA-39002: invalid operation
ORA-39165: Schema XXX was not found.
Import: Release 11.2.0.3.0 - Production on Tue Jan 14 15:29:36 2014
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, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
ORA-39002: invalid operation
ORA-39059: dump file set is incomplete
ORA-39246: cannot locate master table within provided dump files
没有找到相关结果
重要提示:提问者不能发表回复,可以通过评论与回答者沟通,沟通后可以通过编辑功能完善问题描述,以便后续其他人能够更容易理解问题.
1 个回复
梁勇 - 天道酬勤、上善若水。爱好商业智能 2014-12-16 回答
赞同来自:
解决方案:重新导出下,在导入即可。