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
In Paragdb database
1. Create listener
2. Service Name
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
7.select * from [email protected];
8. select * from [email protected];
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.
Looking for someone like-minded? Chances are you’ve already got one thing in common.
15,000 New members.
Soulmates sees over 15,000 new faces every month.
#1 Customer service.
Feel safe and secure, with help from our award-winning customer service team.
Recently joined Soulmates.
Meet some of our latest members.
Online Dating Success Stories.
Intrepid explorers who’ve found the person of their dreams.
Kristian & Zoe.
"We met through Soulmates four years ago. Although were both based in London, the chances of us meeting by other means were slim. We just got married! Zoe is the most wonderful woman Ive ever met, and I know we are going to have an extremely happy life together."
Laura & Phil.
"Phil and I got married just over a year after we met on my first ever internet date through Guardian Soulmates. Weve been recommending the site to friends ever since. Thank you!" (Photography credit to Michael OSullivan)
Robin & Alec.
"I just wanted to let you know that you have another success story! My boyfriend, who I met via your site about two years ago, just proposed and we are getting married next year. THANK YOU!"
Alex & Rosie.
"Rosie and I met through Soulmates and were married in October, just 17 months later. Were wonderfully happy together!"
How does it work?
Find your Soulmate in three easy steps.
Register your free account today.