This article explain From postgres, how can we fetch oracle db data. For this we need to use foreign data wrapper and foreign table concepts. DEMO: 1.Create oracle client on postgres server: ...
db_link
How to do import using network_link in oracle
By using network_link parameter, we can directly import the data from source database to target database without generating the dump file. This will need a database link between source and target db ....
GLOBAL_NAMES parameter and database link in oracle
GLOBAL_NAMES specifies whether a database link is required to have the same name as the database to which it connects. GLOBAL_NAMES is either set to FALSE OR TRUE. If the value of GLOBAL_NAMES is fals...
create database link from oracle to sql server
Creating a database link from oracle to oracle database is easy. But setting up db_link from oracle to mssql server isn’t straight forward. We need to do odbc setup. Its knows as heterogeneous d...