Managing Synonyms
A synonym is an alias for a schema object. You can create, view and drop a synonym.
Synonyms can provide a level of security by masking the name and owner of an object and by providing location transparency for remote objects of a distributed database. Also, they are convenient to use and reduce the complexity of SQL statements for database users.
- Creating Synonyms
Create synonyms using Object Browser. - Viewing a Synonym
Select a synonym from the Object Selection pane. - Dropping a Synonym
Select a synonym from the Object Selection pane and click Drop.
See Also:
"Oracle Database Administrator’s Guide" for information about synonyms
Parent topic: Managing Database Objects with Object Browser
Creating Synonyms
Create synonyms using Object Browser.
To create a synonym:
Parent topic: Managing Synonyms
Viewing a Synonym
Select a synonym from the Object Selection pane.
To view a synonym:
Parent topic: Managing Synonyms
Dropping a Synonym
Select a synonym from the Object Selection pane and click Drop.
To drop a synonym in Object Browser:
Parent topic: Managing Synonyms