老榕树社区

标题: 奇怪:不能drop role [打印本页]

作者: uniojeque    时间: 2014-9-1 09:39
标题: 奇怪:不能drop role
不能删除角色,现象如下,在sqlplus中查询invalid对象,有一个 但在 dba studio 里面看起来该对象是valid的,不过这个不管了 我现在的问题是想知道,是否仅仅是重新编译该包就可以了呢? 还是需要重新运行什么脚本? 有什么需要注意的地方? SQL> drop role insertonly; drop role insertonly * ERROR 位于第 1 行: ORA-00604: error occurred at recursive SQL level 1 ORA-04031: unable to allocate 4032 bytes of shared memory (\"shared pool\",\"unknown object\",\"joxlod: in ehe\",\"ioc_allocate_pal" ORA-06512: at \"SYS.HTTP_SECURITY_CASCADE\", line 0 ORA-06512: at line 3 SQL> create or replace role insertonly; create or replace role insertonly * ERROR 位于第 1 行: ORA-00922: missing or invalid option SQL> create role onlyinsert; 角色已创建 SQL> drop role onlyinsert; drop role onlyinsert * ERROR 位于第 1 行: ORA-00600: internal error code, arguments: [26599], [1], [226], [], [], [], [], [] ORA-06512: at \"SYS.HTTP_SECURITY_CASCADE\", line 0 ORA-06512: at line 3 SQL> conn sys/change_on_install@e450 已连接。 SQL> select * from user_objects where status = \'INVALID\'; OBJECT_NAME -------------------------------------------------------------------------------- SUBOBJECT_NAME OBJECT_ID DATA_OBJECT_ID OBJECT_TYPE ------------------------------ ---------- -------------- ------------------ CREATED LAST_DDL_T TIMESTAMP STATUS T G S ---------- ---------- ------------------- ------- - - - DBMS_REPCAT_AUTH 3506 PACKAGE BODY 19-5月 -01 19-5月 -01 2001-05-19:18:47:33 INVALID N N N SQL> select OBJECT_NAME from user_objects where status = \'INVALID\'; OBJECT_NAME -------------------------------------------------------------------------------- DBMS_REPCAT_AUTH




欢迎光临 老榕树社区 (http://club.lrswl.com/) Powered by Discuz! X3