Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Creating Database link in database

Software Development


Reply
 
Thread Tools Search this Thread
  #1  
Old 28-01-2010
Member
 
Join Date: Jan 2010
Posts: 49
Creating Database link in database
  

I am using oracle 9i enterprise edition and it would a new practice for me.I, actually wanted to know the basic concepts of database link and what are the privileges should I have to create this link.What is database link? What is the difference between a public and a private database link?

Reply With Quote
  #2  
Old 28-01-2010
Member
 
Join Date: May 2008
Posts: 2,293
Database link in database

Database Link:

Database link is a pointer that is used to access the data from remote database while you are working on local database.You have some proper privileges to create this link.

To know the current privilege regarding database link,you have to query on the ROLE_SYS_PRIVS view :

SELECT DISTINCT PRIVILEGE AS "Database Link Privileges"
FROM ROLE_SYS_PRIVS
WHERE PRIVILEGE IN ( 'CREATE SESSION','CREATE DATABASE LINK',
'CREATE PUBLIC DATABASE LINK');


Or you can execute the privs.sql script to know about link privileges type :

SQL> @privs
Reply With Quote
  #3  
Old 28-01-2010
Member
 
Join Date: Oct 2005
Posts: 2,389
Creating private database link

When you create a database link, you have to decide which user will permission to access it.

I am going to create a private database link which will point to remote database. I am a normal user and have such privilege to create the private database link.

The syntax would be as follows :

CREATE DATABASE LINK <Link name>
CONNECT TO <current user> USING <Remote database>;
Reply With Quote
  #4  
Old 28-01-2010
Member
 
Join Date: May 2008
Posts: 2,383
Creating public database link

Creating public database link:

The creation of public database link,you have "CREATE PUBLIC DATABASE LINK" privilege and use the PUBLIIC keyword.

The syntax to create the public database link:

CREATE PUBLIC DATABASE LINK <Public_Link_name>
CONNECT TO <Current user> USING <'Name of remote database'>;
__________________
The FIFA Manager 2009 PC Game
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Creating Database link in database"
Thread Thread Starter Forum Replies Last Post
How to link access database with VB 6.0 in VB projects. Meena89 Software Development 3 17-11-2010 01:49 AM
Creating savepoint in database afidelino Software Development 4 13-03-2010 10:14 PM
Creating view in oracle database Aileen_L Software Development 5 11-02-2010 04:27 PM
Creating partition of database tables LaMarcus Software Development 4 30-01-2010 11:48 AM
Creating xml File from database table in VB.Net Jateen Software Development 2 29-12-2008 06:20 PM


All times are GMT +5.5. The time now is 11:17 PM.