-
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
-
Are you dropping objects owned by that user at the same time as trying to drop the user with cascade?
Assistance is Futile...
-
hi, no i just want drop the whole user
-
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.
-
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
-
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.
-
hi i look to triger body and all mentioned table in trigger body is exist
any other suggestion???
-
i have done it i just create table user_history$ under sys and after that i trz drop user and it works.. ..........incredible
-
what made u create that object dear did u read it from metalink
Behind The Success And Failure Of A Man Is A Woman
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|