Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Unable to drop oracle package
Pat Minnis wrote:
>
> Get the text of the package if you can.
> Create or replace the package with minimum needed syntax.
> If that works, see if you can export the whole database.
> ora-00600 always worries me.
> If that ok, create the package with the proper text.
>
> deltondm_at_my-dejanews.com wrote in message
> <77d6pt$ock$1_at_nnrp1.dejanews.com>...
> >Trying to drop a package which seems to be corrupted, but unable to do so.
> >Also tried to do an export, keep getting the following error.
> >
> >EXP-00008: ORACLE error 600 encountered
> >ORA-00600: internal error code, arguments: [12700], [16781700], [15], [],
> [],
> >[], [], []
> >EXP-00000: Export terminated unsuccessfully
> >
> >
> >Even tried dropping the user, same error.
> >
> >Any help would be appreciated.
> >
> >Oracle workgroup server 7.3.4 NT4.0 service pack 3
> >
> >-----------== Posted via Deja News, The Discussion Network ==----------
> >http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
We had 7.3.4.0 on Solaris and it had HEAPS of problems with PL/SQL
especially if using pl/sql tables..(lots of ora-060 errors)...Upgrading
to 7.3.4.1 resolved these problems...
--