Re: Oracle 8.0.4 export error EXP-0008: Oracle error 4045 encoutered

Hi all,

I remember that I ran catexp7.exp on this database.... I found out the export not successful when exporting 'System' objects... I tried to reran catexp.sql and then catalog.sql scripts but still cannot fix....:-(

Thanks again for any help....

H.V

Huy Vu <huyv_at_usa.net> wrote in message
news:cBJ63.42759$r_1.22814030_at_newscontent-02.sprint.ca...
> Hi all,
>
> I tried to export an oracle database (8.0.4, update to 8.0.4.3 on Dec Unix
> 4.0D) but it stopped with errors below:
>
> . about to export EXTDATA1's tables via Conventional Path ...
> . exporting referential integrity constraints
> . exporting posttables actions
> EXP-00008: ORACLE error 4045 encountered
> ORA-04045: errors during recompilation/revalidation of
> SYS.DBMS_AQ_IMPORT_INTERL
> ORA-06552: PL/SQL: Compilation unit analysis terminated
> ORA-06553: PLS-905: object SYS.AQ$_SUBSCRIBERS is invalid
> ORA-06508: PL/SQL: could not find program unit being called
> ORA-06512: at line 1
> ORA-06512: at "SYS.DBMS_SYS_SQL", line 787
> ORA-06512: at "SYS.DBMS_SQL", line 328
> ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 82
> ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 133
> ORA-06512: at line 1
> EXP-00000: Export terminated unsuccessfully
>
> I don't remember with .sql scripts that I tried to ran to allow to import
a
> dump file of Oracle 7....to Oracle 8....
>
>
> Thanks in advance for any idea..
>
> H.V
>
>
Received on Wed Jun 09 1999 - 22:55:16 CDT