Reply-To: "Mustapha Nuvvercrap" From: "Mustapha Nuvvercrap" Newsgroups: comp.databases.oracle.server,comp.databases.oracle.misc References: <95e9p6$jnt$1@cubacola.tninet.se> Subject: Re: Dropping a user locked by error ora-00600 Lines: 27 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 Message-ID: Date: Fri, 02 Feb 2001 12:53:00 GMT NNTP-Posting-Host: 144.132.45.148 X-Complaints-To: news@bigpond.net.au X-Trace: news-server.bigpond.net.au 981118380 144.132.45.148 (Fri, 02 Feb 2001 23:53:00 EST) NNTP-Posting-Date: Fri, 02 Feb 2001 23:53:00 EST Organization: BigPond Internet Services (http://www.bigpond.net.au) Create a dummy package with the create or replace syntax with the same name as one of them ? "carl-henrik hilborn" wrote in message news:95e9p6$jnt$1@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@mail.bip.net > >