请各位帮忙看看：impdp导入出错
源库： 10g 单机SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bi
PL/SQL Release 10.2.0.5.0 - Production
CORE 10.2.0.5.0 Production
TNS for Linux: Version 10.2.0.5.0 - Production
NLSRTL Version 10.2.0.5.0 - Production
$ uname -a
Linux yunrac2 2.6.18-238.el5 #1 SMP Sun Dec 19 14:22:44 EST 2010 x86_64 x86_64 x86_64 GNU/Linux
目标库：11g rac 3个节点
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
CORE 11.2.0.3.0 Production
TNS for Linux: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production
SQL> !
$ uname -a
Linux zhptdb3 2.6.32-279.el6.x86_64 #1 SMP Wed Jun 13 18:24:36 EDT 2012 x86_64 x86_64 x86_64 GNU/Linux
用户：
SQL> select username,default_tablespace,u.lock_date,account_status from dba_users u where username='CLOUDPIM';
USERNAME DEFAULT_TABLESPACE LOCK_DATE ACCOUNT_STATUS
------------------------------ ------------------------------ ----------- --------------------------------
CLOUDPIM CLOUDPIM OPEN
SQL>
导出脚本：
cat cloudpim0109.sh
expdp \'/ as sysdba \' directory=exp_dir dumpfile=cloudpim0109_%U.expdp schemas=cloudpim EXCLUDE=STATISTICS filesize=4g parallel=4 logfile=cloudpim0109.log
导出的文件为cloudpim0109_01.expdp ~ cloudpim0109_99.expdp
导入脚本：
SQL> create directory exp_dir as '/data1/expdp';
Directory created
SQL> grant read,write on directory exp_dir to public;
Grant succeeded
impdp \'/ as sysdba \' directory=exp_dir dumpfile=cloudpim0109_%U.expdp full=y parallel=6 logfile=cloudpim0114.log table_exists_action=truncate
导入报错如下：
$ impdp \'/ as sysdba \' directory=exp_dir dumpfile=cloudpim0109_%U.expdp full=y parallel=6 logfile=cloudpim0114.log table_exists_action=truncate
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
请问：
这个问题如何解决？
多次grant read ,write on ......;
或
重建 directory 可能会解决，具体原因不知道。求解释！！！！ mql535 发表于 2014-1-14 15:44 static/image/common/back.gif
多次grant read ,write on ......;
或
重建 directory 可能会解决，具体原因不知道。求解释！！！！ ...
我试试，谢谢。 wangyq 发表于 2014-1-14 15:48 static/image/common/back.gif
我试试，谢谢。
重新赋权 还是同样的问题。 在mos上查了一下，应该是一个bug, patch number: 8819709...
你可以下载一个补丁自己打一下.. 多谢大家提醒，问题找到了，导出的时候意外终止了，意外导出没有问题，多谢各位。
页:
[1]