Re: Export problem (during .exporting posttable actions)

From: Dan Benwell <dan_at_benwell.co.uk>
Date: Sat, 21 Aug 1999 15:20:56 +0100
Message-ID: <7pmcj9$4uk$1@lure.pipex.net>

Could try rerunning catalog.sql and catproc.sql from $ORACLE_HOME/rdbms/admin in server manager connected internal

su - oracle
cd $ORACLE_HOME/rdbms/admin
$ORACLE_HOME/bin/svrmgrl
connect internal
@catalog
@catproc

And try again. Looks like the there are errors in some of the procedures. Catalog and catproc
regenerated the data dictionary and procedural options.

Hope this helps,
Dan

NetComrade <netcomradeNOSPAM_at_earthlink.net> wrote in message news:37bce720.43584093_at_news.earthlink.net...
> everything was doing fine until the following step....
> Anybody has any idea?
>
> Thanx
>
> . exporting posttables actions
> EXP-00008: ORACLE error 4045 encountered
> ORA-04045: errors during recompilation/revalidation of
> SYS.DBMS_AQ_IMPORT_INTERN
> AL
> 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
>
Received on Sat Aug 21 1999 - 09:20:56 CDT