Create Dblink synonyms

Database link

The primary role of Dblink is data access between two databases

Create DATABASE link My_test connect to testdbname identified by Testpass
Using ' (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = dev) (PORT = 1521))
(Connect_data =
(SERVER = dedicated)
(service_name = Ora8)
)
)‘;

My_test:dblink's name.

Testdbname: The user name of the database to connect to

Testpass: The password of the database to connect to

Using the following information: locally established TNS connected to the remote database

synonyms (synonyms):

The literal understanding is the meaning of the alias, similar to the function of the attempt. is a mapping relationship.

1. Create a synonym statement:

Create public synonym table_name for user.table_name;

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

table_name the table corresponding to the remote database.

User remote database username

　

In addition, if you are creating a synonym for a table on a remote database, you need to create a database link to extend access, and then create a database synonym using the following statement:

Create synonym table_name for [email protected]_link;

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

2. Delete synonyms:

Drop public synonym table_name;

3. See 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.

Create Dblink synonyms