disabled type. Oracle is complex and interconnected and changing things can cause some database objects to become "invalid". Oracle CREATE SYNONYM. Step by Step manually creation of an Oracle Post navigation â Oracle Log Switches Per Hour In-Memory Column Store Report â oracle - Why public synonyms become invalid - Database ⦠ACTION PLAN ===== 1. drop the synonym: SQL> drop public synonym XMLCONCAT; To get the list of invalid objects for the current logged in user, run the following SQL query: Select object_name, object_type, created, last_ddl_time From user_objects Where status != 'VALID'. Like a package, may depend on a certain oracle table or view or synonym. Here was Oracleâs response in response to query asked earlier "As per Oracle note Note 761961.1 is still unavailable , since it is in the publishing process. ⦠Articles Oracle 8i Oracle 9i Oracle 10g Oracle 11g Oracle 12c Oracle 13c Oracle 18c Oracle 19c Oracle 21c Miscellaneous PL/SQL SQL Oracle RAC Oracle Apps WebLogic Linux MySQL invalid synonym oracle Invalid Synonym on Database Package â oracle-tech