473,395 Members | 1,701 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes and contribute your articles to a community of 473,395 developers and data experts.

Oracle Database Links (DB Link)

debasisdas
8,127 Expert 4TB
DATABASE LINK
===============
A database link is a path through which a remote user in another database can connect to any other database. Once created database link exists as an object in the user schema.

DATABASE LINK -3 TYPES
=======================
PRIVATE--DEFAULT--A PRIVATE DBLINK IS ONLY AVAILABLE TO THE USER WHO HAS CREATED IT.IT IS NOT POSSIBLE FOR A USER TO GRANT ACCESS ON A PRIVATE DBLINK TO OTHER USERS.
-------
PUBLIC--IT IS AVAILABLE TO ALL THE USERS.
-------
SHARED--SHARED DATABASE LINK USES SHARED SERVER CONNECTION TO SUPPORT DATABASE LINK CONNECTION. IF THERE ARE MULTIPLE CONCURRENT DATABASE LINK ACCESS INTO A REMOTE DATABASE, SHARED DATABASE LINK CAN BE USED TO REDUCE THE NO OF SERVER CONNECTIONS REQUIRED. WITHOUT THE SHARED CLAUSE EACH DATABASE LINK CONNECTION REQUIRES A SEPARATE CONNECTION TO THE REMOTE DATABASE.

In dblink we can use 2 types of login.
-------------------------------------------------------
1.DEFAULT LOGIN----USER NAME AND PASWORD IS SAME IN BOTH THE DATABASES.

Syntax
-------------
CREATE [PUBLIC] DATABASE LINK <DB.N.> CONNECT TO CURRENT_USER USING<'CONNECTION STRING'>

Expand|Select|Wrap|Line Numbers
  1. create public database link daslink connect to current_user  using 'ORCL' 
2.EXPLICIT LOGIN-----USER NAME AND PASWORD IS DIFFERENT IN BOTH THE DATABASES.

Syntax
-------------
CREATE [PUBLIC|SHARED] DATABASE LINK <DBLINK NAME> CONNECT TO<USERNAME>IDENTIFIED BY<PASSWORD> USING<'CONNECTION STRING'>

Expand|Select|Wrap|Line Numbers
  1. CREATE PUBLIC DATABASE LINK DDLNK CONNECT TO SCOTT IDENTIFIED BY TIGER USING 'ORCL'
  2.  

Note:---TO CREATE PUBLIC DBLINK THE USER MUST HAVE CREATE PUBLIC DATABASE LINK SYSTEM PREVILEDGE.
May 8 '07 #1
0 16337

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: A.M. de Jong | last post by:
Hi, In our environment a database view is based on columns in a table from an oracle database. This is a linked server I believe. I am told that since we use this construction no where clause...
0
by: Daisy | last post by:
To empower your .NET web services with the Oracle Database, download Oracle Data Provider for .NET (ODP.NET) from : http://otn.oracle.com/tech/windows/odpnet/index.html Try out the new features...
2
by: Ike | last post by:
Can someone show me how I might be able to connect to two separate databases, and create a query from the two? I understand in Oracle this is referred to as "database links" but is there a more...
1
by: Steve Kershaw | last post by:
Can somebody help me please?! I'm using MS Visual Studios 2005 and in the Server Explorer I can see the Oracle database but when I click on the tables link I don't see any tables and the "+"...
1
by: ananth | last post by:
Hi All, I have a java code that retrievies values from a table in a oracle database. There are more than 100 columns and 100000 records for the table in the database and i am able to...
2
by: Aguyngueran | last post by:
Hello there I've got two Oracle database instances on different machines, creating database link with name TEST causes to create database link with name: 1) on the first machine...
0
by: Jack | last post by:
Training Classes for Oracle10g, 9i, 8i Certification training in Oracle10g and 9i: DBA, Developer, Discoverer. training conducted at your location worldwide. Courseware licensing also available....
0
by: Winder | last post by:
Training Classes for Oracle10g, 9i, 8i Certification training in Oracle10g and 9i: DBA, Developer, Discoverer. training conducted at your location worldwide. Courseware licensing also available....
0
by: akshalika | last post by:
I am new to Biztalk. In my project we need to connect oracle database and insert data into oracle table using BizTalk project. I use WCF Adapter pack(SP2). I create biztalk project then using Consume...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.