Re: Full database export problem...

Chris,

Not sure but check the status column in dba_objects for DBMS_AQ_SYS_EXP_INTERNAL: it may "just" be that the package is invalid. The "just" is because you then have to work out why.

Was the database upgraded from an older version. You sometimes get funnies with packages left older from older builds. The package may be looking for a view or table that no longer exists.

I'm not saying this is the answer, but it might be.

Len

>Hi,
>
>I was trying to do a full database export. However, I got the following
>error messages:
>
>>>>>>
>About to export the entire database ...
>. exporting tablespace definitions
>. exporting profiles
>. exporting user definitions
>. exporting roles
>EXP-00008: ORACLE error 4068 encountered
>ORA-04068: existing state of packages has been discarded
>ORA-04063: package body "SYS.DBMS_AQ_SYS_EXP_INTERNAL" has errors
>ORA-06508: PL/SQL: could not find program unit being called
>ORA-06512: at "SYS.DBMS_AQ_EXP_QUEUES", line 141
>ORA-06512: at line 1
>EXP-00083: The previous problem occurred when calling
>SYS.DBMS_AQ_EXP_QUEUES.grant_sysprivs_exp
>. exporting resource costs
>
>...
>
>. exporting bitmap, functional and extensible indexes
>. 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_AQADM_SYS" has errors
>ORA-06508: PL/SQL: could not find program unit being called
>ORA-06512: at "SYS.DBMS_AQ_IMPORT_INTERNAL", line 85
>ORA-06512: at line 1
>ORA-06512: at "SYS.DBMS_SYS_SQL", line 1076
>ORA-06512: at "SYS.DBMS_SQL", line 316
>ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 84
>ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 135
>ORA-06512: at line 1
>EXP-00000: Export terminated unsuccessfully
>>
>>
><<<<<
>
>Does anyone know what 's going on? I am using oracle 8i (version 8.1.6)
>on solaris 8.
>
>Thanks,
>
>-- Chris
  Received on Sun Dec 17 2000 - 10:13:47 CST