HomeНаука и техникаRelated VideosMore From: Parag Mahalle

How to Create Database Link in Oracle. /* Step By Step /*

73 ratings | 7613 views
Today I am showing you. How to create Database link (DB Link) in Oracle. What is Database Link ( DB Link ) ? A database link is a schema object in one database that enables you to access objects on another database. I have 2 databases 1. paragdb 2. orcl In Paragdb database 1. Create listener 2. Service Name 3. In Orcl Database 1. Create Listener 2. Service Name 3. Create new User 4.Grant connect,resource,create database link to username; 5. open user 6. create database link 1. create database link link1 connect to scott identified by tiger using 'connect_primary''; 7.select * from [email protected]; 8. select * from [email protected]; 9. views 1. select * from user_db_links; 2. select * from all_db_links; 10. conn sys as sysdba 11. grant public database link to username; 12. select * from dba_db_links; 13. conn username/pass 14. create public database link plink connect to scott identified by tiger using 'connect_primary'; 15. drop database link. drop database link link1; To follow this steps you will also create oracle database link. It is very easy to understand.
Html code for embedding videos on your blog
Text Comments (3)
suni (4 months ago)
thank you so much
Liton Biswas (1 year ago)
Thanks Bro Its working
sagar gupta (1 year ago)
Nice Work bro...

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.