2.14 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
2.14.1 Creating Synonyms
Create synonyms using Object Browser.
To create a synonym:
Parent topic: Managing Synonyms
2.14.2 Viewing a Synonym
Select a synonym from the Object Selection pane.
To view a synonym:
Parent topic: Managing Synonyms
2.14.3 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