ORACLE BACKUP ERROR

[oracle8]

Hi!
I was doing an oracle full database backup using EXP80. After backing up all the tables of our database, the back up stops and an error occured "ORA-4045: errors during recomplitation/revalidation of SYS.DBMS_AQ_IMPORT_INTERNAL". Any suggestions on how to solve this problem ?
Thank you very much.

Oracle8

 

[MikeLacey]

Hi,

I had a similar error with Oracle7 a while ago and it turned out to be data dictionary corruption. We fixed it by re-running the standard catalog and catproc scripts.

Before you go any further though -- stop the database and take a cold backup, don't skip this. Mike
michael.j.lacey@ntlworld.com
Email welcome if you're in a hurry or something -- but post in tek-tips as well please, and I will post my reply here as well.