Home » RDBMS Server » Networking and Gateways » moving table by using db links (11.2.o.3, Linux)
moving table by using db links [message #633161] Wed, 11 February 2015 13:07 Go to next message
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
Re: moving table by using db links [message #633162 is a reply to message #633161] Wed, 11 February 2015 13:16 Go to previous messageGo to next message
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/
Re: moving table by using db links [message #633237 is a reply to message #633162] Thu, 12 February 2015 11:24 Go to previous messageGo to next message
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
Re: moving table by using db links [message #633239 is a reply to message #633237] Thu, 12 February 2015 11:31 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
INSERT INTO TABLEB SELECT * FROM TABLEA@NEW_DATABSE_LINK;
Re: moving table by using db links [message #633346 is a reply to message #633239] Mon, 16 February 2015 10:35 Go to previous messageGo to next message
mutyalanaidug
Messages: 6
Registered: January 2015
Junior Member
Thank you for solving my problem
Re: moving table by using db links [message #635910 is a reply to message #633346] Sat, 11 April 2015 05:52 Go to previous messageGo to next message
annaya
Messages: 1
Registered: April 2015
Junior Member
-> i want script for trying to moving data from table A which is on fdev to table b which is on hdev
__________________
emma

[Updated on: Sat, 11 April 2015 05:52]

Report message to a moderator

Re: moving table by using db links [message #635912 is a reply to message #635910] Sat, 11 April 2015 07:27 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

INSERT SELECT

Previous Topic: Not able to login
Next Topic: VALID_NODE_CHECKING_REGISTRATION_listener_name
Goto Forum:
  


Current Time: Thu Mar 28 16:30:19 CDT 2024