Export problem (during .exporting posttable actions) 
Author Message
 Export problem (during .exporting posttable actions)

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



Wed, 18 Jun 1902 08:00:00 GMT
 Export problem (during .exporting posttable actions)

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

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


Quote:
> 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



Wed, 18 Jun 1902 08:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. DTS Export: How to have nulls export as blanks on fixed width export

2. export file problem - how to close/unuse the exported file

3. Export problem: "0 rows exported"..

4. Upgrading from SQL 6.5 to 2000 - error during export and import via named pipes step

5. including NULLS during export

6. SQL Server Upgrade Wizard Fails During Import/Export

7. Change name file during a Export data

8. Upgrading from SQL 6.5 to 2000 - error during export and import via named pipes step

9. ORA 06553 - PLS 561 during export from 8.1.6

10. ORA-04031 during export

11. ORA-00600 during schema export Oracle 8.1.5

12. export during transaction?


 
Powered by phpBB® Forum Software