DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: can not drop user

  1. #1
    Join Date
    Apr 2001
    Posts
    127

    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?

  2. #2
    Join Date
    Apr 2001
    Posts
    127
    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

  3. #3
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    what type of object is it

  4. #4
    Join Date
    Apr 2001
    Posts
    127
    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

  5. #5
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    is someone using it?

  6. #6
    Join Date
    Apr 2001
    Posts
    127
    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

  7. #7
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    and is someone using it

  8. #8
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    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
  •  


Click Here to Expand Forum to Full Width