Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003

    Unanswered: ORA-00980 'synonym translation no longer valid'

    Now I face only this problem when invoke oracle report.Cloud anyone help me to fix it?

  2. #2
    Join Date
    Sep 2003
    Milan, Italy
    It means the object pointed too by the synonym has been dropped, or that you no longer have the privileges to access it.


    SQL> create table tt (x number, y date);

    Table created.

    SQL> create synonym uuu for tt;

    Synonym created.

    SQL> select * from uuu;

    no rows selected

    SQL> drop table tt;

    Table dropped.

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts