Oracle Database Links (DB Link)
A database link is a path through which a remote user in another database can connect to any other database. Once created the database link exists as an object in the user schema.
Type of DB Links
There are 3 types of DB links. They are as follows:
1. PRIVATE: When the DB links is created, it is created under Private mode as default. The 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.
2. PUBLIC: The Public DBLINK is available to all the users and all users can have the access without any restrictions.
3. SHARED: Shared database link uses share the 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 number of server connections required. Without the shared clause each database link connection requires a separate connection to the remote database.
Types of Logins:
In dblink we can use 2 types of login. They are as follows:
1. DEFAULT LOGIN: The User name and Password is same in both the databases.
Syntax
======
CREATE [PUBLIC] DATABASE LINK CONNECT TO CURRENT_USER USING
Code: (Text)
Create public database link daslink connect to current_user using ‘ORCL’
2. EXPLICIT LOGIN: The User Name and Password is different in both the databases.
Syntax
======
CREATE [PUBLIC|SHARED] DATABASE LINK CONNECT TOIDENTIFIED BY USING
Code: (text)
CREATE PUBLIC DATABASE LINK DDLNK CONNECT TO SCOTT IDENTIFIED BY TIGER USING ‘ORCL’
Note: To create the public DBLINK the user must have create public database link system privileges.
path:D:\app\prasanthb\product\11.1.0\db_1\NETWORK\ADMIN
oracle2test =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.7.107)(PORT = 1526))
)
(CONNECT_DATA =
(SERVICE_NAME =VIS)
(SRVR = DEDICATED)
)
)
3 comments:
Howdy, i read your blog occasionally and i own a similar one and i was just curious if you get a lot of spam remarks?
If so how do you protect against it, any plugin or anything you can advise?
I get so much lately it's driving me mad so any help is very much appreciated.
my blog post :: hard drive repair
Heya! I just wanted to ask if you ever have any trouble with hackers?
My last blog (wordpress) was hacked and I ended up losing a few months of hard work due to
no back up. Do you have any methods to prevent hackers?
my web page mypinoyvideos.net
Heya just wanted to give you a quick heads up and let you know a few of the images
aren't loading properly. I'm not sure why but I think its a linking issue.
I've tried it in two different browsers and both show the same results.
My blog post: data recovery crack
Post a Comment