Oracle Create Dblink

1. View the permissions required to create Dblink

   Sqlplus/as SYSDBA

   SELECT * from User_sys_privs t where T.privilege like Upper ('%link% ');

2. Authorization to the appropriate user

   Grant drop public database link, create DATABASE link, create the public database link to oracle_user_name;

3. Login to create a dblink user

   Conn Oracle_user_name/password

4. Create Dblink

   Create DATABASE link My_dblink_name

   Connect to Oracle_user_naem identified by password

   Using ' (DESCRIPTION =

   (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.238) (PORT = 1521))

   (Connect_data =

   (SERVER = dedicated)

   (service_name = ORCL)

   )

   )‘;

   To see if the creation was successful

   SELECT * from Dba_db_links;

Oracle Create Dblink