-
can not drop user
Hi,
When I run the following command I got the ORA-21700 error:
SQL> drop user test1 cascade;
drop user test1 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
How can I drop the user?
-
just found out the reason the drop user fails is that there is a type in that schema that can't be dropped:
SQL> drop type TEST1.SYS_PLSQL_834664_189_2;
drop type TEST1.SYS_PLSQL_834664_189_2
*
ERROR at line 1:
ORA-21700: object does not exist or is marked for delete
-
what type of object is it
-
SQL> select object_name, object_type, status from user_objects;
OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_TYPE STATUS
------------------- -------
SYS_PLSQL_834664_189_2
TYPE VALID
-
-
I have manully dropped all objects under that schema except this one
-
-
i would guess some sort of system table corruption.. can you enable trace and post the trace file (with sys option = yes)