Synonyms May Cause Invalidation or Recompilation of SQL Queries

When a synonym or object is newly created or dropped, some SQL queries and DDL statements may be invalidated or recompiled.

The following lists the invalidation and recompilation behavior for SQL queries and DDL statements:

1. All SQL queries that depend on a public synonym are invalidated if you create a private synonym with the same name for one of the following objects:

   • private synonym

   • table

   • view

   • sequence

   • materialized view

   • cache group

   • PL/SQL object including procedures, functions, and packages

2. All SQL queries that depend on a private synonym or schema object are invalidated when a private synonym or schema object is dropped.