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