删除索引报错

显示全部楼层 · 2007-7-19 08:57:15

删除索引报这个错？谁遇到过？
DROP INDEX EQUINE.PK_QUOTE_FORM_DATA
ORA-00604: error occurred at recursive SQL level 1
ORA-04068: existing state of packages has been discarded
ORA-04065: not executed, altered or dropped stored procedure
"SYS.DICTIONARY_OBJ_OWNER"
ORA-06508: PL/SQL: could not find program unit being called:
"SYS.DICTIONARY_OBJ_OWNER"
ORA-06512: at line 2

千问 · 2007-7-19 08:57:15

没有遇到过
帮你顶下

千问 · 2007-7-19 08:57:15

http://space.itpub.net/104152/viewspace-557723

千问 · 2007-7-19 08:57:15

查查这个 function dictionary_obj_owner还在吗?
create or replace function dictionary_obj_owner return varchar2 is
begin
return dbms_standard.dictionary_obj_owner;
end;

千问 · 2007-7-19 08:57:15

数据字典有问题了吧？

千问 · 2007-7-19 08:57:15

该索引是主键产生的吧，是没法删除的。

千问 · 2007-7-19 08:57:15

SYS.DICTIONARY_OBJ_OWNER不存在？是否被误删除了？

千问 · 2007-7-19 08:57:15

create or replace function dictionary_obj_owner return varchar2 is
begin
return dbms_standard.dictionary_obj_owner;
end;