Create Synonym

From DBArtisan
Jump to: navigation, search

Go Up to Available object actions by DBMS

You can perform an ad hoc Create Synonym operation against a specific object displayed in the Datasource Navigator/Explorer. For background information, see Synonyms.

Platform Availability

You can perform this operation against the following object types:

Functions

Materialized Views

Packages

Package Bodies

Procedures

Sequences

Tables

Views

To Create a Synonym for an Object

  1. Expand the node corresponding to one of the object types supported for this operation, listed in the table above.
    The right-hand pane is populated with all objects of that type.
  2. Right-click the target object and select Create Synonym from the context menu.
  3. A Create Synonym wizard opens.

For information on using the wizard, see Synonyms Wizard (Oracle).