Database Administration (MOSC)

MOSC Banner

can drop user

edited Apr 10, 2012 7:41AM in Database Administration (MOSC) 5 commentsAnswered
SQL> drop user test ;
drop user test
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-00942: table or view does not exist

I have so many invalid objects

NameFromLastDDL FUNCTION 10/31/2011 1:56:47 PM
SET_TABLESPACE PROCEDURE 04/10/2012 10:07:05 AM
BMD9P_MAIN.CHECK_UNIQUE PROCEDURE 04/10/2012 10:07:05 AM
BMD9P_MAIN.UPDATE_OBJECT_PATHS PROCEDURE 04/10/2012 10:07:05 AM
CTCCUST.LOYALTYUPDATE PROCEDURE 04/10/2012 10:07:05 AM
CTCCUST.UPDATE_SUBSCRIBER_ATTR PROCEDURE 04/10/2012 10:07:05 AM
CTCCUST.UPDATE_WEB_STORE_ATTR PROCEDURE 04/10/2012 10:07:05 AM
WMSYS.NO_VM_ALTER_PROC PROCEDURE 04/10/2012 10:07:05 AM
WMSYS.NO_VM_CREATE_PROC PROCEDURE 04/10/2012 10:07:05 AM
WMSYS.NO_VM_DROP_PROC PROCEDURE 04/10/2012 10:07:05 AM
XDB.XDB$PATCHUPSCHEMA PROCEDURE 04/10/2012 10:07:06 AM
AQ$AQ_EVENT_TABLE VIEW 10/22/2005 9:49:22 PM

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