Re: Export problem

The export won't work because a package owned by SYS has a state of INVALID. This query:

SQL> select owner, object_name, object_type, status   2 from all_objects
  3 where object_name like '%DBMS_SYS_SQL%';

OWNER     OBJECT_NAME                    OBJECT_TYPE  STATUS
--------- ------------------------------ ------------ ---------
SYS       DBMS_SYS_SQL                   PACKAGE      		VALID
SYS       DBMS_SYS_SQL                   PACKAGE BODY 	VALID

... executed on your instance(s) will probably indicate the package/package body "DBMS_SYS_SQL", owned by SYS, needs to be recompiled / references an INVALID object / has a status of INVALID for some reason.

Try    ALTER PACKAGE sys.dbms_sys_sql  COMPILE BODY         and/or
        ALTER PACKAGE sys.dbms_sys_sql  COMPILE PACKAGE  

... if this doesn't work you may at least get more informative error messages back.

cheers,
peter.wenker_at_MCI.com

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