ORA-27092: size of file exceeds file size limit of the process

有位朋友遇到这个问题,关键是他不理解这些英文哈。
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

ORA-27092: size of file exceeds file size limit of the process
解决方法:
Cause: an attempt was made to open a
file that exceeds the process`s file size limit (ulimit), additional
information shows the current limit (logical blocks) and the size of the file
(logical blocks)
Action: increase the processes file size
limit (ulimit) and retry

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  就可以了

posted @ 2009-02-03 23:05  HiEagle  阅读(2268)  评论(0编辑  收藏  举报