当前位置: 代码迷 >> Oracle管理 >> 急1解决方案
  详细解决方案

急1解决方案

热度:19   发布时间:2016-04-24 05:51:35.0
急!!!!!!!!!!!!!!!1
impdp epma/epmazj@EPAPPZJ directory=A1 dumpfile=20090103_%U.dmp full=y Parallel=5

Import: Release 10.2.0.3.0 - 64bit Production on Tuesday, 03 February, 2009 20:09:34

Copyright (c) 2003, 2005, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
ORA-39002: invalid operation
ORA-31694: master table "EPMA"."SYS_IMPORT_FULL_01" failed to load/unload
ORA-31640: unable to open dump file "/yxora/20090103_04.dmp" for read
ORA-19505: failed to identify file "/yxora/20090103_04.dmp"
ORA-27092: size of file exceeds file size limit of the process
Additional information: 262143
Additional information: 1886713


------解决方案--------------------
导不进,原表是不是存在重复主键了?
------解决方案--------------------
看错误提示应该是没有找到要导入的dmp文件,把路径写全试试
------解决方案--------------------
Additional information: 262143 ===> current limit of the logical blocks
Additional information: 1886713 ===> size of the logical blocks of the file
修改limit文件 filesize = -1
取消了文件大小的限制.
解决方法具体操作:
在aix中 $ulimit -f -1 就可以了
------解决方案--------------------
楼上的应该更有道理,这边没有环境,lz可以一下的。
------解决方案--------------------
学习~
  相关解决方案