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.
- 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.