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
DON’T MISS OUT!
Subscribe To Newsletter
Be the first to get latest updates and exclusive content straight to your email inbox.
Stay Updated
Give it a try, you can unsubscribe anytime.

Check Also

Oracle 10g to 11g Enhancements (Difference between Oracle 10g and 11g)

Difference between Oracle 10g and 11g 1- Enhanced Automatic Memory Management System Oracle 9i automated …

Leave a Reply

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

DON’T MISS OUT!
Subscribe To Newsletter
Be the first to get latest updates and exclusive content straight to your email inbox.
Stay Updated
Give it a try, you can unsubscribe anytime.
close-link
GET OUR LATEST CONTENT IN YOUR INBOX

SUBSCRIBE 
Your information will never be shared
close-link
Enquiry
Submit
close-link
Sign-up for exclusive content. Be the first to hear about DBA Centre Blogs.
Subscribe