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?
Database link in database
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"
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 :
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>;
Grand Theft Auto 4 PC Video Game
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
|Tags: database link, global, private, privileges, privssql file, public|
|Thread Tools||Search this Thread|
|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|