can not drop user
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: can not drop user

  1. #1
    Join Date
    Feb 2000
    Location
    New York,U.S.A.
    Posts
    245
    Hi, all
    I can not drop user even with cascade, I bounced the database and still can not do it. The error message is

    ERROR at line 1:
    ORA-00600: internal error code, arguments: [15013], [24], [], [], [], [], [],
    []

    Does anyone has any experience with this? Thanks for help.

  2. #2
    Join Date
    Nov 2000
    Posts
    9
    Open a TAR w/Oracle when you get these "... internal errs.."

    What user (not SYS/SYSTEM right?)?
    Michael T Hudacko
    Senior Oracle DBA

  3. #3
    Join Date
    Sep 2000
    Posts
    384
    Now itself take a full export dump.Right now???
    Radhakrishnan.M

  4. #4
    Join Date
    Feb 2000
    Location
    New York,U.S.A.
    Posts
    245
    Right, it created a huge dump file... I logged a tar with oracle support, but I can not wait....

  5. #5
    Join Date
    Nov 2000
    Posts
    205
    What user are you trying to drop?

  6. #6
    Join Date
    Feb 2000
    Location
    New York,U.S.A.
    Posts
    245
    Just a regular user created by SYSTEM. I never have a problem dropping a user before....

  7. #7
    Join Date
    Nov 2000
    Posts
    205
    Not totally sure. Since you bounced db, can't be anything with open sessions etc. Maybe an export of the user and import back, then dropping.. just guessing here, since it looks like some corruption at OS level or something.

    Anyway, good luck
    Nirasha

  8. #8
    Join Date
    Jun 2000
    Posts
    295
    Have you tried to drop all of his objects first, then drop
    user without cascade option?

  9. #9
    Join Date
    Feb 2000
    Location
    New York,U.S.A.
    Posts
    245
    I dropped the default_tablespace for this user, it still does not work. By the way, I have the problem with dropping queues owned by this user. I will try to exp and imp the user and try again see if it helps. Thanks all of you.

  10. #10
    Join Date
    Feb 2000
    Location
    New York,U.S.A.
    Posts
    245
    I exported and imported the user and still can not drop the user...

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