Re: I decide! Help on export or taller bridge is waiting for me

I run catproc.sql and catexp.sql as INTERNAL: I received 'statement processed' without errors but it doesn't works!

The final solution was :
1) Drop all the objects created by catproc.sql and catexp.sql 2) Rerun catproc.sql and catexp.sql connected as internal

Hoping it was useful for others!

"Andre van Winssen \(andrew\)" <andrew-no-spam-svp_at_info.nl> wrote in message news:<3c8f7abd$0$24734$4d4ebb8e_at_news.nl.uu.net>...
> so did you try rerunning CATPROC.SQL and CATEXP.SQL while connected
>
> as INTERNAL?
>
> These scripts are in %oracle_home%\rdbms\admin.
>
> Hth,
>
> Andre van Winssen
>
> "Marco Zamuner" <mzamuner_at_ateikon.com> wrote in message
> news:7ffd4d85.0203130713.706dfbf2_at_posting.google.com...
> > I'm going crazy! Please someone help me!
> >
> > I'm trying to export an old DB Oracle 7.3 on a very old server.
> > I launched exp73 ... and received this message:
> > EXP-00008: ORACLE error 4068 encountered
> > ORA-04068: existing state of packages has been discarded
> > ORA-04067: not executed, package body "SYS.DBMS_EXPORT_EXTENSION" does
> > not exist
> >
> > ORA-06508: PL/SQL: could not find program unit being called
> > ORA-06512: at line 1
> > Export terminated successfully with warnings.
> >
> > I open a SqlPlus session as sys to execute DMBS package obviously not
> > created and received this one:
> > ERROR:
> > ORA-04068: existing state of packages has been discarded
> > ORA-04067: not executed, package body "SYS.DBMS_OUTPUT" does not exist
> > ORA-06508: PL/SQL: could not find program unit being called
> > ORA-06512: at line 1
> > Error accessing package DBMS_APPLICATION_INFO
> > ERROR:
> > ORA-04068: existing state of packages has been discarded
> > ORA-04067: not executed, package body "SYS.DBMS_APPLICATION_INFO" does
> > not
> > exist
> > ORA-06508: PL/SQL: could not find program unit being called
> > ORA-06512: at line 1
> >
> > So, I launched DBMS packaged receving OK responses.
> >
> > Results:
> > Same errors while exporting, same errors while opening SqlPlus.
> >
> > Any ideas?
> >
> > Marco ;( Zamuner
> > Ateikon Group
Received on Thu Mar 14 2002 - 04:11:41 CST