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 includes:

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. The right-hand pane is populated with all objects of that type.
  2. Right-click the target object, and then select Create Synonym from the context menu.
  3. The Create Synonym wizard opens. For information on using the wizard, see Synonyms Wizard (Oracle).