Oracle Database Link

 

Oracle Net can be used for communication between databases: a user session of a database can execute SQL statements for another database.

This can be done through the database link.

 

 

Create database link sync

Connect to store identified by admin123 using 'db244 ';

 

 

Sync is the name of the created link, store is the user name of another database, admin123 is the user password of another database, and db244 is the Oracle Net configured locally pointing to another database;

Select * from users @ sync;

Users is a table in another database.

A user's session starts a session for a remote database. you can log on transparently using the store identity and run the query there. The result is returned to the local database and then returned to the user.

 

 

As long as the link mode has the appropriate permissions, you can use the link to execute any SQL statement. For example, delete, modify, and DDL statements.

From qm4050