AskDba.org Weblog

While trying to do a full export for 10.2.0.3 database, we were getting following errors About to export the entire database ... . exporting tablespace definitions . exporting profiles . exporting user definitions . exporting roles . exporting resource costs . exporting rollback segment definitions . exporting database links . exporting sequence numbers . exporting directory aliases . exporting context namespaces . exporting foreign function library names . exporting PUBLIC type synonyms EXP-00008: ORACLE error 980 encountered ORA-00980: synonym translation is no longer valid EXP-00000: Export terminated unsuccessfully So as to debug the problem, we set errorstack for ORA-00980 as follows and tried exporting again alter system set events '980 trace name errorstack level 3'; Export job again failed with error but this time it generated a trace file in user_dump_dest location. We got the following sql as failing statement in tracefile ORA-00980: synonym translation is no longer valid Current SQL … Read entire article »