Oracle in a Nutshell

Name

CREATE/DROP SYNONYM

Synopsis

CREATE Syntax:

CREATE [PUBLIC] SYNONYM synonym_name
FOR [schema.]object_name[@dblink]

DROP Syntax:

DROP [PUBLIC] SYNONYM [schema.]synonym_name

Creates or removes a public or private synonym for a database object.

Keywords

PUBLIC

Specifies that this synonym will be available to all users. If omitted, the synonym will be available only to the schema owner.

synonym_name

Name of the new synonym.

object_name

Name of the object to which the synonym will refer. It may include a reference to a remote database by appending the @dblink syntax.

Tip

Oracle resolves object names in the current schema first, so a PUBLIC synonym will be used only if the object name is not prefaced with a schema name, is not followed by a dblink, and does not exist in the current schema.

Common keywords and clauses: dblink, schema.