Prompt for a table or view that does not exist when Oracle deletes a user ____oracle

The most recent deletion of users in Oracle is always an error, and the message is:

ORA-00604: Recursive SQL Layer 1 error occurred

ORA-00942: Table or view does not exist

According to the online solution found that the following test method is feasible:

Turn on Oracle Tracking

Alter session Set Sql_trace=ture

Execution of our deletion

Drop User xxx

Turn off tracing

Alter session set Sql_trace=false;

Then, under the Oracle Server installation directory

E:\Program files (x86) \oracle\product\10.2.0\admin\ database name \udump Find the most recent trace file

Orcl_ the database name _4468.TRC then executes tkprof E:\Program Files (x86) \oracle\product\10.2.0\admin\ database name \udump\orcl_ database name _4468 on the command line. TRC C:\log.txt The trace information file into a text file Log.txt

Open Log.txt Find the error message you can see

The following statement encountered a error during parse:

Delete from System.aq$_internet_agent_privs WHERE db_username = Nls_upper (: 1

Error encountered:ora-00942 again desc system.aq$_internet_agent_privs discovery is aq$_internet_agent_privs This table does not exist caused by

Find the script based on online solutions E:\Program Files (x86) \oracle\product\10.2.0\db_1\rdbms\admin/catqueue.sql

You can then execute the script to create the table

Performing a delete user after restarting the database can be performed successfully