删除用户出错,详细见内容

zly0216

SQL> drop user iim cascade;             -----不光是IIM用户,其它所有用户都一样.包括系统用户
drop user iim cascade
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-00942: table or view does not exist


用tkprof 查看TRACE文件
The following statements encountered a error during parse:
delete from system.aq$_internet_agent_privs WHERE db_username = NLS_UPPER(:1)
Error encountered: ORA-00942
--------------------------------------------------------------------------------
alter session set sql_trace=off
Error encountered: ORA-00922

操作系统AIX 5100-05   数据库为RAC 9.2.0.4.0

请各位大哥帮忙解决..小弟先谢过了.....

numenhuang

1. sqlplus "/as sysdba"
2. desc system.aq$_internet_agent_privs
3. 如果不存在，则执行$ORACLE_HOME/rdbms/admin/catqueue.sql
4. desc system.aq$_internet_agent_privs 如果存在，继续执行drop user