-
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
Oracle 8, 8i, 9i OCP DBA
Oracle 6/6i OCP DEV
Sun Solaris8 SCSA
MCDBA 2000
-
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
Oracle 8, 8i, 9i OCP DBA
Oracle 6/6i OCP DEV
Sun Solaris8 SCSA
MCDBA 2000
-
-
I have manully dropped all objects under that schema except this one
Oracle 8, 8i, 9i OCP DBA
Oracle 6/6i OCP DEV
Sun Solaris8 SCSA
MCDBA 2000
-
-
i would guess some sort of system table corruption.. can you enable trace and post the trace file (with sys option = yes)
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|