Creating, Editing or Deleting Synonyms

Oracle Enterprise Manager allows you to manage the list of synonyms associated with the current database through the Synonyms property sheet.

Use Oracle Enterprise Manager to create, edit or delete synonyms for an existing schema object or to view the settings for an existing synonym. You can create a synonym from an object on a local database or an accessible database on the network.

To manage a synonym:

  1. Navigate to the Database Home page.

  2. On the Schema tab, click Synonyms in the Database Objects section.

    The Synonyms Search page appears containing a results table listing all current synonyms for the current database.

  3. Choose the action you want to perform. You can create a new synonym or you can select a synonym from the results list and choose one of the actions from the command drop down list.

    Click Help for more information about synonyms.

Related Topics

Enterprise Manager Information Roadmap