Database Administration (MOSC)

MOSC Banner

I cannot drop oracle schema

edited Jun 2, 2009 10:41PM in Database Administration (MOSC) 1 commentAnswered
 Hi to all,
I try to drop one oracle schema and I receive the following error:

SQL> drop user tstuser cascade;
drop user tstuser cascade
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-21700: object does not exist or is marked for delete

In alert.log I found the following information:

Warning: drop_queue_table: No evaluation for the queue table: TSTUSER.BNA_MQ

Then I try to find the above object but of course I didn't found.

SQL> select owner,object_name,status from dba_objects where owner='TSTUSER' and object_name='BNA_MQ';

no rows selected

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center