![invalid synonym invalid synonym](http://www.arrayserver.com/wiki/images/9/9d/HeatmapOfGeneSet.png)
![invalid synonym invalid synonym](http://www.seaslugforum.net/images/m14297d.jpg)
So it is the dependency mechanism in Oracle10 that marks the synonyms as invalid when the underlying object changes or becomes invalid. And although the definition of the user_objects view changed a bit to reflect new object types, the part that displays the status column did not change. This is the same test in our new 10.2.0.3 database:Īpparently, Oracle10 marks the synonyms as invalid. The synonym always remains valid as it really doesn't have a status. SQL> create or replace procedure p1 (p_tekst in varchar2) SQL> select object_name,status from user_objectsĢ where object_name in ('P1','P2','P1_SYN','P2_SYN') This filter tokenizes synonyms with whatever tokenizer and token filters appear before it in the chain. So I had to reproduce it myself using SQL*Plus. The synonym analyzer is then configured with the filter. The problem with those tools - I think - is that I don't get to know what query they are executing. I do not have access to SYS or SYSTEM accounts. And apparently that's what they meant by "invalid synonyms".īut then a developer colleague who was testing our new environment, wanted me to have a look and showed me invalid synonyms in his SQL Navigator gui. I have access to an oracle DBA account but I am unable to revalidate Oracle invalid synonyms. 45 synonyms for invalid: patient, sufferer, convalescent, valetudinarian, disabled, ill, sick, poorly. It's the underlying object that can be invalid or missing. having no cogency or legal force invalidverb. After all, a synonym cannot be invalid: it is only another word for an object. someone who is incapacitated by a chronic illness or injury invalidadjective. I frowned a little, thinking it was probably a project manager mixing up words and concepts picked up by his team members. This morning I read an email discussion about having invalid synonyms in our new Oracle 10.2.0.3 database. Definition of INVALID (noun): sick person who cannot look after themselves.