Monday , September 25 2017
Home / Oracle DBA / Oracle Database Links

Oracle Database Links

Database Links

  1. It is the object which will pull remote database data to local database.
  2. While creating dblink, we need to know username and password of remote database.
  3. Apart from username and password of remote db, we need to have tns entry in tnsnames.ora of local db and tnsping command should work.
# To create database link
SQL> create database link dev.com
         connect to scott identified by tiger
         using ‘dev’;
# To retrieve data from remote database
SQL> select * from scott.emp@dev.com;
Read More:
TYPES OF ERRORS in Oracle database
NETWORKING WITH ORACLE
SOX compliance database

Comments

comments

Check Also

How to switch on primary database to physical standby database

After configuration data guard then data is switching  into primary database  to standby database : …

Leave a Reply

Your email address will not be published. Required fields are marked *