Ora-00980 Error In Oracle
Contents |
Last updated: December 17, 2014 - 6:31 pm UTC Category: Database � Version: 9i Whilst you are here, check out some content from the AskTom team: On Rollups, Merges, and Moves Latest
Ora-00980 Solution
Followup You Asked Hi Tom, I run Oracle 7.3 for years in Window ora-00980 synonym translation is no longer valid sap NT machine with an C++ application and it work fine. I recently updated my Oracle to 9i in Windows 2000
How To Find Invalid Synonyms In Oracle
to my new machine (different machine). After Imported the database from my old machine to a new one my application wrote in C++ no longer work and came up with an error ora-00980 synonym translation is no longer valid database link ********* ERROR: CDBException Generated. ORA-00980: synonym translation is no longer valid Option value changed. Please close and Restart Application. *************** Thanks. your answer is greatly appreciated. David and we said... that means you lost some object/access to some object when you did your move. That error simply means "synonym is still here, but the object it points to is inaccessible". It could be inaccessible synonym translation is no longer valid stack overflow due to a missing grant, or due to the object not being there. You need to find out what synonym it is, query the data dictionary to figure out what object it points to and figure out why you no longer have access to that object. ops$tkyte@ORA920> create synonym s for t; Synonym created. ops$tkyte@ORA920> select * from s where rownum = 1; C ---------- 1 ops$tkyte@ORA920> drop table t; Table dropped. ops$tkyte@ORA920> select * from s where rownum = 1; select * from s where rownum = 1 * ERROR at line 1: ORA-00980: synonym translation is no longer valid Reviews Write a Review ORA-00980: synonym translation is no longer valid", version 9i January 01, 2003 - 2:07 am UTC Reviewer: A reader Thanks Tom your answer is great help. David Even I am facing the same problem March 01, 2005 - 12:51 pm UTC Reviewer: Jignesh from London -- -------------------------------- -- CONNECT TO BRIDGE DATABASE -- -------------------------------- SQL> select banner from v$version; BANNER ---------------------------------------------------------------- Oracle8i Enterprise Edition Release 8.1.7.0.0 - 64bit Production PL/SQL Release 8.1.7.0.0 - Production CORE 8.1.7.0.0 Production TNS for Solaris: Version 8.1.7.0.0 - Production NLSRTL Version 3.4.1.0.0
MySQL MariaDB PostgreSQL SQLite MS Office Excel Access Word Web Development
Drop Synonym In Oracle
HTML CSS Color Picker Languages C Language More ASCII ora-38818: illegal reference to editioned object Table Linux UNIX Java Clipart Techie Humor Advertisement Oracle Basics ALIASES AND AND &
Create Or Replace Synonym
OR BETWEEN COMPARISON OPERATORS DELETE DISTINCT EXISTS FROM GROUP BY HAVING IN INSERT INSERT ALL INTERSECT IS NOT NULL IS NULL JOIN https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:7095288486502 LIKE MINUS NOT OR ORDER BY PIVOT REGEXP_LIKE SELECT SUBQUERY TRUNCATE UNION UNION ALL UPDATE WHERE Oracle Advanced Oracle Cursors Oracle Exception Handling Oracle Foreign Keys Oracle Loops/Conditionals Oracle Transactions Oracle Triggers String/Char Functions Numeric/Math Functions Date/Time Functions Conversion Functions Analytic Functions Advanced Functions https://www.techonthenet.com/oracle/errors/ora00980.php Oracle / PLSQL: ORA-00980 Error Message Learn the cause and how to resolve the ORA-00980 error message in Oracle. Description When you encounter an ORA-00980 error, the following error message will appear: ORA-00980: synonym translation is no longer valid Cause You tried to reference a synonym that no longer exists. Resolution The option(s) to resolve this Oracle error are: Option #1 Reference the object directly (include schema name, if appropriate). Option #2 Re-create the synonym. Share this page: Advertisement Back to top Home | About Us | Contact Us | Testimonials | Donate While using this site, you agree to have read and accepted our Terms of Service and Privacy Policy. We use advertisements to support this website and fund the development of new content. Copyright © 2003-2016 TechOnTheNet.com. All rights reserved.
Early Adopter Program ArcGIS Ideas Esri Support Services ArcGIS Blogs ArcGIS Code Sharing Product Life Cycles Manage Cases Request Case Start Chat Back to results Print Share Is This Content Helpful? http://support.esri.com/technical-article/000010041 Search on GeoNet Submit to ArcGIS Ideas Error: ORA-00980: synonym translation is no longer valid Error Message When using any of the following Spatial Type for Oracle (ESRI ST_GEOMETRY) operators http://searchoracle.techtarget.com/answer/ORA-00980-synonym-translation-is-no-longer-valid from SQL with ArcSDE 9.2 for Oracle server,ST_LineFromWKBST_MlineFromWKBST_MpointFromWKBST_MpolyFromWKBST_PointFromWKBST_PolyFromWKBan error message similar to the following may appear: Code:SQL> UPDATE TABLE1 2 SET GEOMCOLUMN = ST_LINEFROMWKB(LOBCOLUMN) 3 WHERE OBJECTID = 27;Error: ORA-00980: synonym in oracle translation is no longer valid Cause This can occur when public synonyms for these operators exist on the Oracle server, but the operators themselves do not exist. These operators were not implemented in version 9.2, but were implemented in version 9.3. Public synonyms for these and other operators are created when installing early Beta versions of ArcSDE 9.3. The installer for synonym translation is ArcSDE 9.3 final does not create public synonyms for operators; therefore, this condition can occur under the following circumstances: 1. An early version of ArcSDE 9.3 Beta was installed, then2. The Beta was uninstalled, then3. ArcSDE 9.2 was installed. Solution or Workaround Beginning with ArcSDE 9.2 Service Pack 6 and above, please qualify the names of spatial type operators with the name of the owning schema 'SDE', for example: 'SDE.ST_MPointFromWKB'.Uninstalling ArcSDE, or even dropping the Oracle user SDE, does not automatically drop any public synonyms.As the SDE user, these PUBLIC synonyms can be dropped. The following are the SQL commands to do this: Code:DROP PUBLIC SYNONYM ST_LineFromWKB;DROP PUBLIC SYNONYM ST_MLineFromWKB;DROP PUBLIC SYNONYM ST_MPointFromWKB;DROP PUBLIC SYNONYM ST_MPolyFromWKB;DROP PUBLIC SYNONYM ST_PointFromWKB;DROP PUBLIC SYNONYM ST_PolyFromWKB; Created: 5/5/2016 Last Modified: 5/5/2016 Article ID: 000010041 Software: ArcSDE 9.2 Is This Content Helpful? Is This Content Helpful? Yes No We're glad to know this article was helpful. How can we make this better? Submit Contact our Support Team Request Case Start Chat Questions or issues with the site? Send Feedback Privacy Contact Support USA +1-888-377-4575 Name Emai
Topic Backup and recovery Database Admin View All Cloud infrastructure Availability Database design Export, import and migration Installation, upgrades and patches Oracle performance problems and tuning Oracle security Oracle DBA tools Error messages MySQL database Real Application Clusters (RAC) Applications View All Enterprise and business performance management Implementing and upgrading Oracle apps E-Business Suite Fusion applications Hyperion JD Edwards (JDE) PeopleSoft Siebel and Oracle CRM Data Mgmt View All BI (business intelligence) Data quality Data warehousing Metadata Database Admin View All Cloud infrastructure Availability Backup and recovery Database design Export, import and migration Installation, upgrades and patches Oracle performance problems and tuning Oracle security Oracle DBA tools Error messages MySQL database Real Application Clusters (RAC) Development View All BPEL in Oracle Open Source SQL Java / J2EE Stored procedures XML PL/SQL Fusion View All Oracle and BEA Application Server Data and application integration SOA (service-oriented architecture) Infrastructure View All Cloud computing infrastructure Exadata and Exalogic Grid computing Oracle on Linux Operating system Oracle hardware decisions Virtual machine Oracle management View All certification Oracle acquisitions Business process management Market analysis DBA jobs training and certification Small businesses Regulatory compliance Outsourcing Oracle on demand and SaaS Oracle strategy and product roadmap Oracle support services Oracle vs. SAP Oracle Web 2.0 Sun-Oracle infrastructure View All Oracle cloud computing Oracle OS Oracle virtualization Topics Archive View All Oracle DBA jobs Oracle Resources Training and certification Tutorials, tips and FAQs Please select a category Applications Data Mgmt Database Admin Development Fusion Infrastructure Oracle management Sun-Oracle infrastructure Section Problem Solve News Get Started Evaluate Manage Problem Solve Sponsored Communities Q ORA-00980: synonym translation is no longer valid byBrian Peasland While importing an export backup of an Oracle8i database into Oracle9i, it completes with an error at the time of creating a trigger. The message is: "PL/SQL:ORA-00980: synonym translation is no longer valid." Sections Share this item with your net