DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: synonym translation is no longer valid

  1. #1
    Join Date
    May 2002
    Posts
    232
    we accessing remote data by using dblinks and we create a synonyms by using db links.
    i am using synonym in database trigger.Which is used for some remote database table
    trans actions.I was created all synonyms which
    are using remote tables in triggers.I get a error.
    any one help me

    ORA-00980 synonym translation is no longer valid

    Cause: The synonym used is based on a table, view, or synonym that no longer exists.

    Action: Replace the synonym with the name of the object it references or re-create the synonym so that it refers to a valid table, view, or synonym.

    I was created synonym and dblinks
    thanks
    kavitha
    kavitha

  2. #2
    Join Date
    Feb 2001
    Location
    UAE
    Posts
    304
    Looks like somebody has renamed the table. Please check that.
    Agasimani
    OCP(10g/9i/8i/8)

  3. #3
    Join Date
    May 2001
    Location
    Maryland, USA
    Posts
    409
    Synonym will get invalid anytime a base object or the object it references is ALTERED.

    So in addition to checking the Tables being altered, also check if your trigger is calling any other trigger or procedure and if that has been invalidated.
    -- Dilip

Posting Permissions

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


Click Here to Expand Forum to Full Width