
Automatically Create All Missing Synonyms in an Oracle Database
Synonyms are used in place of schema objects in professional database applications because the application user is typically different from the object owner schema. The script below creates synonyms for all the relevant objects in your schema?if they dont exist automatically. This saves you from having to write hundreds of