(running 8.1.6 on solaris)
I am trying to drop a user like so..
drop user IFSAPP cascade;
but I am getting the following errors...
sqlplus> drop user IFSAPP cascade;
drop user IFSAPP cascade
ORA-00604: error occurred at recursive SQL level 1
ORA-00942: table or view does not exist
I have got this problem resolved by running catnoqueue.sql & catqueue.sql from sys/system user. As this script created the Dict. Table reqd. for Advanced Queues even though I am not using any of Advanced Queuing.
Did you recently upgrade?
If yes, then you probably did not all run necessary scripts as SYS.
If that is not your case, then enlarge the SYSTEM datafile or just add a datafile to the SYSTEM tablespace (you might not have enough space is the SYSTEM tablespace).
I suspect it is the 2nd :-)
that was a bug fixed later ...look for metalink docs
Bug like this was in Oracle 9i (9.0.1) v.1 for Solaris
I fixed it thru executing some scripts from catalog.sql but I can't remember exactly whitch of scripts.
Click Here to Expand Forum to Full Width