首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > 数据库 > oracle >

急1解决方案

2012-03-16 
急!!!!!!!!!!!!!!!1impdpepma/epmazj@EPAPPZJ directoryA1dumpfile20090103_%U.dmpfullyParallel5Impo

急!!!!!!!!!!!!!!!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可以一下的。
[解决办法]
学习~

热点排行