Oracle Synonyms DDL

Synonyms are a shorthand method of access to database objects owned and created by various users. Complex schema, object name and connection strings can be reduced to simple a alias. Too deeply nested views can cause serious performance problems, especially if these views are created against other views.

• PUBLIC - only DBAs can create public synonyms. Piblic synonyms ar globally available. Private synonyms is schema specific and available only to that user and the grantees of that user.
• synonym_name.
• schema - the schema where the object resides.
• object_name - name of the object to which the synonym is mapped.
• @dl - a database link that is used if the object resides in another database.