From: Mike Krolewski <mkrolewski@rii.com>
Newsgroups: comp.databases.oracle.server,comp.databases.oracle.misc
Subject: Re: Dropping a user locked by error ora-00600
Date: Fri, 02 Feb 2001 17:28:20 GMT
Organization: Deja.com
Lines: 42
Message-ID: <95eqn4$97t$1@nnrp1.deja.com>
References: <95e9p6$jnt$1@cubacola.tninet.se>
NNTP-Posting-Host: 63.75.139.178
X-Article-Creation-Date: Fri Feb 02 17:28:20 2001 GMT
X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 5.0; Windows NT; DigExt)
X-Http-Proxy: 1.1 x56.deja.com:80 (Squid/1.1.22) for client 63.75.139.178
X-MyDeja-Info: XMYDJUIDmikkrolewski


In article <95e9p6$jnt$1@cubacola.tninet.se>,
  "carl-henrik hilborn" <hilborn@mail.bip.net> wrote:
> 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@mail.bip.net
>
>

ora-600 are generally due to severe data corruption. Try, like the
other writer suggested, to create dummy procedures/packages with just
the headers and no body. Then delete them completely.

When ora-600 happens within a table, the usual fix is to reload the
data associated with the table. I believe most people try removing the
indexes first. I am not sure what one would do with a package.


--
Michael Krolewski
Rosetta Inpharmatics
mkrolewski@rii.com
              Usual disclaimers


Sent via Deja.com
http://www.deja.com/