DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: unable drop user "sorry....uncllose(threat)"

  1. #1
    Join Date
    Oct 2006
    Posts
    11

    Angry unable drop user "sorry....uncllose(threat)"

    hi i try drop user .. drop user 'mm' cascade but it not possible i have this kind of error

    VBO-5530 user cannot be dropped
    ORA-00604: error occurred at recursive SQL level 1
    ORA-00942: table or view does not exist

    i read some article on internet but not works, do you know where is problem and how to solve it
    Reply With Quote

  2. #2
    Join Date
    Jul 2002
    Location
    Northampton, England
    Posts
    612
    Are you dropping objects owned by that user at the same time as trying to drop the user with cascade?
    Assistance is Futile...

  3. #3
    Join Date
    Oct 2006
    Posts
    11

    Question

    hi, no i just want drop the whole user

  4. #4
    Join Date
    Dec 2001
    Posts
    320
    I've seen many times that this was due to wrong installation of XDB option.
    Set events 942 for the session, and examine the trace file generated, this could tell you about the nature of the problem.

    HTH
    Anyone can hold the helm when the sea is calm.

  5. #5
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681
    as an alternative....
    drop first all the users object contents....then drop the user

    spool drop.sql

    select 'drop '||object_type||' '||object_name||';' from user_objects;
    Behind The Success And Failure Of A Man Is A Woman

  6. #6
    Join Date
    Oct 2006
    Location
    Mumbai
    Posts
    184
    Hi,

    There is a trigger "SDO_DROP_USER" under MDSYS user. Look for the trigger text. I suppose any of the table mentioned in the trigger body is not existing in your database.

    Just give it a try.

    in SQL*Plus

    set long 4000
    select * from dba_triggers where trigger_name='SDO_DROP_USER';

    Look for the trigger_body, it will give you details about the trigger.

  7. #7
    Join Date
    Oct 2006
    Posts
    11
    hi i look to triger body and all mentioned table in trigger body is exist
    any other suggestion???

  8. #8
    Join Date
    Oct 2006
    Posts
    11
    i have done it i just create table user_history$ under sys and after that i trz drop user and it works.. ..........incredible

  9. #9
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681
    what made u create that object dear did u read it from metalink
    Behind The Success And Failure Of A Man Is A Woman

  10. #10
    Join Date
    Oct 2006
    Posts
    11
    i read the sql trace file and there was error on delete from table user_history$ ... and so on

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