ORA-00980 error when trying to export using EXP command
I am trying to export a schema to oracle 10 database using EXP command. Let's call the schema "myschema" and the tns name "mydb" to protect the names of the innocent. Anyway, here's the command line which I use
exp myschema/mypassword@mydb file=myschema.dmp grants=y
This works when I try to run the export on other instances, but when I try "mydb" I get the following error.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production With the Partitioning, OLAP and Data Mining options Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set server uses UTF8 character set (possible charset conversion) ... exporting pre-schema procedural objects and actions ... exporting foreign function library names for user MYSCHEMA ... exporting PUBLIC type synonyms EXP-00008: ORACLE error 980 encountered ORA-00980: synonym translation is no longer valid EXP-00000: Export terminated unsuccessfully
Does anyone have any idea? If you need more information, let me know and I will edit this question accordingly.
source to share
This can happen if the JVM installation is corrupted. Try:
SELECT comp_id, schema, status, version, comp_name
FROM dba_registry
ORDER BY 1;
If this returns a string with comp_id JAVAVM with the status "INVALID", you will need to reinstall the Java virtual machine.
Metalink document 276554.1 provides a procedure for this. If you can recover easily, it might be easier to recreate the database and reload it.
EDIT: I found a link to Oracle-base where the poster states that this will uninstall and reinstall the JVM (on Unix), I suppose works on windows with little mods:
( WARNING! You can seriously overlay your database if something is wrong here. BACKUP first! )
cd $ORACLE_HOME/javavm/install
sqlplus / as sysdba
@rmjvm.sql
@initjvm.sql
-- Recompile invalid objects
@?/rdbms/admin/utlrp
The metalink remark is pretty much.
source to share