Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: drop user user_name cascade - question
Select segment_name from dba_segments where owner='FRED';
Then I would pick one segment, and drop that one segment. Then I would repeat for another segment.
If individual segment drops are working correctly, then there's a good chance that a particular segment is throwing a wobbly, and that might be because it has a bazillion extents (select segment_name, count(*) from dba_extents group by owner having owner='FRED'; to check). It could also be that you're running into trouble performing the recursive SQL needed by Oracle to work out what to drop, and maybe a bigger shared pool might help that. It could also be half a dozen other things, I'm afraid.
I've been known to drop 300 tables individually, successfuly, where a drop user cascade failed to work.
Regards
HJR
"Tom Miskiewicz" <miskiewicz2_at_no.spam.yahoo.com> wrote in message
news:Gl_p9.4$Ih3.2297_at_news.ecrc.de...
> OK, after another couple of hours I interrupted this user drop
> and as good as nothing has been done in this time. I'm getting
> really pissed off. I cannot delete any table with the Oracle
> Enterprise Manager too. Can someone please tell me what can
> I do know, to get rid of the user with all his objects?
>
>
Received on Sat Oct 12 2002 - 16:07:46 CDT