i want to get the data from a remote oracle database table into my local oracle database. i heard of the "database link" but unable to interpret it
can you help me how to get the data from tat remote db table..
CREATE DATABASE LINK "<REMOTE_DB_NAME>" CONNECT TO <REMOTE_USERNAME> identified by <REMOTE_PASSWORD> USING '<REMOTE_DB_NAME>';
Select * from <REMOTE_TABLE_NAME>@<REMOTE_DB_NAME>;
Create <LOCAL_TABLE_NAME> as select * from <REMOTE_TABLE_NAME>@<REMOTE_DB_NAME>;
Should be the same for both Local and Remote Database
Select * from <LOCAL_TABLE_NAME>;