Web9 Oracle Rdb Journal – Synonyms and Rename Statement The alter synonym can be executed online, even if some applications are still running. These may be reporting … WebCOMPILE. Use this clause to compile synonym. A synonym places a dependency on its target object and becomes invalid if the target object is changed or dropped. When you …
How to compile/drop public synonym? - An Oracle Spin by Alex Lima
WebALTER PUBLIC SYNONYM emp_table COMPILE; The following statement causes synonym offices to remain a noneditioned object if editioning is later enabled for schema object type SYNONYM in the schema that contains the synonym offices: ALTER SYNONYM offices … ALTER SESSION SET CURRENT_SCHEMA I have an application which requires us to … WebThe command “alter synonym [name] compile” is not documented and as such, it is not supported. Although it works in some circumstances it is not meant to be used by the users directly. This is the expected behavior. If all the synonyms have to compiled then run the recompilation script as SYS. You May Also Like immovable joints of the skull are called
ALTER SYNONYM - Oracle Help Center
WebMar 3, 2024 · 1 Answer. Sorted by: 7. If you ALTER a table that is referenced by a view, or even DROP a table, the view is marked as invalid and can't be accessed even if the changes to the table (s) would not make the view's code incorrect. In that case the view needs to be re-compiled: ALTER VIEW some_view COMPILE; More details in the manual: WebThe syntax to create a synonym in Oracle is: CREATE [OR REPLACE] [PUBLIC] SYNONYM [schema .] synonym_name FOR [schema .] object_name [@ dblink]; OR REPLACE Allows you to recreate the synonym (if it already exists) without having to issue a DROP synonym command. PUBLIC It means that the synonym is a public synonym and is accessible to all … WebJan 26, 2005 · ORA-00940: invalid ALTER command While running "ALTER SYNONYM owner.synonym COMPILE;" as system returns: "ORA-01031: insufficient privileges" So what is going on here? And how is a DBA supposed to make all of the synonyms valid? Steven Added on Jan 26 2005 4 comments 796 views immovable joint found only between skull bone