Oracle_synonyms (synonyms)

Oracle Synonyms (Synonyms) Summary

Synonyms English [' s?n?n?mz] [' s?n?n?mz] synonyms (synonym noun plural);

Similar to the functionality of a view, is a mapping relationship.

(1) syntax for creating synonyms

Create public synonym table_name for user.table_name;

The first user_table and the second user_table can be different from each other.

In addition, if you want to create a synonym for a table on a remote database, you need to create a database link to extend the access.

Then use the following statement to create a database synonym: "CREATE synonym table_name for [email protected]_link;

Create or replace synonym monthhours for [email protected];

You may need to authorize the current user (User2) in User users: Grant Select/delete/update on User2

(2) Delete synonyms

Drop public synonyms table_name;

(3) Query all synonyms

SELECT * from dba_synonyms;

Synonyms have the following benefits:

Save a lot of database space, the operation of different users of the same table is not much different;

The scope of the extended database enables seamless interaction between different database users;

Synonyms can be created on different database servers and connected over a network.

　　

Oracle_synonyms (synonyms)