eygle.com   eygle.com
eygle.com  
 
eygle.com - 留言簿 - 回复留言 - Powered by eYgLe.Com
返回留言簿
回 复 留 言
留言ID:
留言原文:
To: 蓋老師
    發現如下錯誤,
SQL> select sum(bytes) from dba_segments;
select sum(bytes) from dba_segments
 *
ERROR at line 1:
ORA-04063: package body "SYS.DBMS_SPACE_ADMIN" has errors

檢查dba_object , status 為INVALID 的物件如下
  OWNER OBJECT_NAME SUBOBJECT_NAME OBJECT_ID DATA_OBJECT_ID OBJECT_TYPE
1 SYS DBMS_SPACE_ADMIN 3248 PACKAGE BODY
2 SYS ODCIARGDESC $VSN_1 3379 TYPE
3 SYS ODCICOLINFO $VSN_1 3362 TYPE
4 SYS ODCICOST $VSN_1 3377 TYPE
5 SYS ODCIINDEXINFO $VSN_1 3366 TYPE
6 SYS ODCIINDEXINFO $VSN_2 3367 TYPE

手工編譯 SYS.DBMS_SPACE_ADMIN 出現ORA-04030 out of process memory when trying to allocate 694016 bytes 錯誤, 請幫忙看看問題在哪?

idle> @/oracle/DBMS_SPACE_ADMIN.pkb
CREATE OR REPLACE PACKAGE BODY SYS.dbms_space_admin wrapped
*
ERROR at line 1:
ORA-04030: out of process memory when trying to allocate 694016 bytes (PLS non-l

ib
hp,PAR.Carchktb)
From: Haiyuan
2010.03.02 20:40
管理密码: 请输入管理密码, 否则无法回复.
斑竹昵称:
信息图标: ( 随机 )


BB 代码:
内容:

如果想删除回复, 请点击最下面的删除回复按钮.
删 除 回 复
管理密码: 请输入管理员密码, 只有版主才能删除回复.
Copyright © 2003~2012 eygle.com All Rights Reserved.
Powered by: www.eygle.com