Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Dropping a user locked by error ora-00600
Create a dummy package with the create or replace syntax with the same name as one of them ?
"carl-henrik hilborn" <hilborn_at_mail.bip.net> wrote in message
news:95e9p6$jnt$1_at_cubacola.tninet.se...
> Hello!
>
> I have a big problem; I am doing some rather straight forward PL/SQL
> developing on an 8.1.5i database. I have also made the misstake to create
a
> circular reference between two packages. As a result from this they
> invalidate each other and cannot be re-compiled.
> When I try to drop the packages or user, (drop user 'user' cascade), the
> error ora-00600 occurs.
>
> How can I resolve this? Does anyone have a similar experience?
>
> I appreciate any help on the matter
>
> --
> Regards
> Carl-Henrik Hilborn
> hilborn_at_mail.bip.net
>
>
Received on Fri Feb 02 2001 - 06:53:00 CST