OraFAQ Forum: Networking and Gateways » moving table by using db links

Home » RDBMS Server » Networking and Gateways » moving table by using db links (11.2.o.3, Linux)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

moving table by using db links [message #633161]

Wed, 11 February 2015 13:07

mutyalanaidug
Messages: 6
Registered: January 2015

Junior Member

Hi all,

i have created the a public database link in between database hdev and fdev successfully

-> i want script for trying to moving data from table A which is on fdev to table b which is on hdev

could you please send script regarding this?

thank you

Report message to a moderator

Re: moving table by using db links [message #633162 is a reply to message #633161]

Wed, 11 February 2015 13:16

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>i have created the a public database link in between database hdev and fdev successfully
do you speak SQL?
If so, please SHOW us exactly how & where you CREATE DATABASE LINK.
See we don't know if you issued CREATE DATABASE LINK while logged into hdev or fdev database.
Do you want to "push" the data from fdev or do you want to "pull" the data to hdev?
Details matter!

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/ and read http://www.orafaq.com/forum/t/174502/

Report message to a moderator

Re: moving table by using db links [message #633237 is a reply to message #633162]

Thu, 12 February 2015 11:24

mutyalanaidug
Messages: 6
Registered: January 2015

Junior Member

i have created database link in hdev database, i an trying to take the data from fdev database to hdev database and the data which i want to pull from table A which is on fdev . so i want a sql/script how to move the table from one database to another using databaselink

thank you

Report message to a moderator