Re: Export problem

My brain woke up... running dbmsrepc.sql fixed this problem. Curious, though why the export would die because a procedure was screwed up - especially one that was allowing the database to continue to work without problems.

Glenn Stauffer <stauffer_at_voicenet.com> wrote in article <01bbe723$97c36fe0$6a7167cf_at_sabena>...
> Anyone know how to fix this? This error happens on three database
> instances. Oracle version 7.2.3; all instances upgraded from version
> 7.1.6.x. Dec Alpha 2100; Digital Unix 3.2c.
>
> This is the error that comes at the end of a full database export:
>
> . exporting referential integrity constraints
> . exporting posttables actions
> EXP-00008: ORACLE error 4068 encountered
> ORA-04068: existing state of packages has been discarded
> ORA-04063: has errors
> ORA-04063: package body "SYS.DBMS_REPCAT_MAS" has errors
> ORA-06508: PL/SQL: could not find program unit being called
> ORA-06512: at line 1
> ORA-06512: at "SYS.DBMS_SYS_SQL", line 348
> ORA-06512: at "SYS.DBMS_SQL", line 134
> ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 64
> ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 115
> ORA-06512: at line 1
> EXP-00222:
> System error message 2
> EXP-00000: Export terminated unsuccessfully
>
> Thanks for any help,
>
> Glenn Stauffer
>
Received on Wed Dec 11 1996 - 00:00:00 CST