Drop User command fails with errors ORA-00604 and ORA-00942
(Doc ID 375954.1)
Last updated on JUNE 15, 2022
Applies to:
Oracle Database - Enterprise Edition - Version 9.2.0.1 to 11.2.0.2 [Release 9.2 to 11.2]Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
When trying to drop a user, the command fails with errors ORA-00604 and ORA-00942
Example
-------------
SQL> drop user <USER> ;
drop user <USER>
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-00942: table or view does not exist
SQL trace (10046) trace will show a dml operation performed on system.aq$_internet_agent_privs
table.
----------------------------------------------------------------------------------------------------------
PARSE ERROR #5:len=78 dep=1 uid=0 oct=7 lid=0 tim=1416609304389 err=942
delete from system.aq$_internet_agent_privs WHERE db_username = NLS_UPPER(:1)
EXEC #1:c=70000,e=552054,p=148,cr=448,cu=0,mis=0,r=0,dep=0,og=4,tim=
1416609309213
ERROR #1:err=604 tim=145060793
STAT #2 id=1 cnt=0 pid=0 pos=1 obj=3490 op='TABLE ACCESS FULL OBJ#(3490) '
----------------------------------------------------------------------------------------------------------
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |