Create DB link

35 views
Skip to first unread message

Tareg Ali

unread,
Aug 29, 2013, 8:24:52 AM8/29/13
to oracle...@googlegroups.com
hi guys ..

i want to create DB line between different data base for different system is it possible or there is any query for this issue 

Best Regards,

Tareg Ali  

Michael Moore

unread,
Aug 29, 2013, 10:47:22 AM8/29/13
to oracle-plsql


--
--
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to Oracle...@googlegroups.com
To unsubscribe from this group, send email to
Oracle-PLSQL...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
 
---
You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group.
To unsubscribe from this group and stop receiving emails from it, send an email to oracle-plsql...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

SANTOSH NIKAM

unread,
Aug 30, 2013, 12:47:31 AM8/30/13
to oracle...@googlegroups.com
-- Create database link 
create database link 
  connect to <db user name which you connect from)
  using '(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST =<db ip address>)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = <db name>)))';



--

Tareg Ali

unread,
Sep 1, 2013, 3:32:46 AM9/1/13
to oracle...@googlegroups.com
Thank Q you ...
Reply all
Reply to author
Forward
0 new messages