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

  • 相关阅读:
    数据结构笔记
    并查集
    计算两个数的最大公约数和最小公倍数
    行盒
    浏览器兼容性和布局
    Java中HashMap等的实现要点浅析
    关于js异步上传文件
    填充路径时所使用的 “非零环绕规则”
    XP极限编程
    假如森林里有一棵树倒下了
  • 原文地址:https://www.cnblogs.com/zjp8023/p/ORASQL.html
Copyright © 2020-2023  润新知