Friday , July 21 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

DATA BASE LINKS

DATABASE LINKS: What are the db links? create a link from one database to another …

Leave a Reply

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