Re: Can't Restore Dumped File

Try recompiling the package from a SQL*Plus session and then showing the errors generated e.g.

SQL> alter package invalid_package compile body; SQL> show errors

Andy

AbdulAti Mustafa <abdulati_at_emirates.net.ae> wrote in message news:3a6f76b2.1991539_at_news.aei.ca...
>
> Thanks Andy;
>
> I am not getting any error message when I recompile or do any other
> recreation.
>
> Abdulati
>
> >What is the error message that you get when recompiling the packages?
> >
> >Andy
> >
> >AbdulAti Mustafa <abdulati_at_emirates.net.ae> wrote in message
> >news:3a6df2f2.987876_at_news.aei.ca...
> >> Hi Every one;
> >>
> >> I WOULD LIKE TO REPORT THE FOLLOWING PROBLEM i met WHILE I WAS
> >> RESTORING A DUMPed FILE.
> >>
> >> 1- FIRST I IMPORTED THE ARCHIVE FILE AND THERE WERE NO report of
> >> ERROR OR WARNING IN THE LOG FILE.
> >>
> >> 2- THEN I PRESSED THE ''RESTORE' TO RESTORE THE APPLICATION
> >>
> >> 3- AFTER 40% OF THE WORK WAS DONE I RECEIVED THE FOLLOWING ERROR
> >>
> >> MESSAGE: #RME-00233 AND ORA-06508.
> >>
> >> THEY STATED THAT A ''PROGRAM UNIT'' COULD NOT BE FOUND.
> >>
> >>
> >> 4- I VIEWED THE "OBJECT STATUS" AND FOUND TWO INVALID "BACKAGE
> >> BODY"; NAMELY
> >> A) CK_UTIL AND B) RMMAC
> >>
> >> 5- I RECREATED THE BACKAGES; RECOMPILED AND RECONCILED THE
> >> OBECTS AND DID ALL POSIBLE THINGS WITH THE 'RECREATION''
> >> BUT THE TWO BACKAGE BODIES REMAIN ALWAYS ''INVALID''.
> >>
> >> 6- BY THE WAY; WHEN I TRY TO OPEN A ''NEW APPLICATION'' I
> >> RECEIVE THE SAME ERROR MESSAGE. FOR THAT REASON I CANN'T
> >>
> >> EVEN START ANY NEW ACTIVITY.
> >>
> >>
> >> I WILL BE VERY GRATEFULL FOR ANY ADVICE AND HELP.
> >> YOURS
> >> ABDULATI
> >>
> >> abdulati_at_hotmail.com
> >>
> >
> >
>
Received on Thu Jan 25 2001 - 09:56:58 CET