Dear Sir,

I am exporting a database from one system and importing it in another system. after importing its shows the error ORA-00980 tranlation is no longer valid everywhere i can see the solution but my question is

1)its working well with with the previous system why after importing its showing error?
2)i dont want to solve the problem after importing and when it throws exception instead i want don't want this problem to arise
3)after importing i have to again create schema and synonym is there a way to solve it

so after importing it should work perfectly without throwing exception

can you please help me sir?

SQL> create table t (
  2    x int
  3  );

Table created.

SQL>
SQL> create synonym s for chris.t;

Synonym created.

SQL>
SQL> select * from s;

no rows selected

SQL>
SQL> drop table t purge;

Table dropped.

SQL>
SQL> select * from s;
select * from s
              *
ERROR at line 1:
ORA-00980: synonym translation is no longer valid

select * from user_synonyms s
where  not exists (
  select * from dba_objects d
  where  s.table_owner = d.owner
  and    s.table_name = d.object_name
);

SYNONYM_NAME  TABLE_OWNER  TABLE_NAME  DB_LINK  
S             CHRIS        T