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

    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
    Location
    Milan, Italy
    Posts
    130
    It means the object pointed too by the synonym has been dropped, or that you no longer have the privileges to access it.

    E.g.

    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
  •