Home » SQL & PL/SQL » SQL & PL/SQL » how to use remote database data
how to use remote database data [message #271235] Mon, 01 October 2007 00:05 Go to next message
ashish_pass1
Messages: 114
Registered: August 2006
Location: delhi
Senior Member
hello sir

i am having two table of same datatype.
one table(dummy) having data residing on remote database.
other table(on live) having no data but same datatype.

now i want to fetch those data from dummy to live.how can i do that.
please help me out.

thanxx
regds
ashish
Re: how to use remote database data [message #271241 is a reply to message #271235] Mon, 01 October 2007 00:20 Go to previous messageGo to next message
dhananjay
Messages: 635
Registered: March 2002
Location: Mumbai
Senior Member
hi,

create a database link ?


regards,
Re: how to use remote database data [message #271244 is a reply to message #271241] Mon, 01 October 2007 00:32 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Export-import?
Re: how to use remote database data [message #271252 is a reply to message #271235] Mon, 01 October 2007 00:55 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

After creating database link, use direct mode insert.

insert into table_name select ....
Re: how to use remote database data [message #271256 is a reply to message #271252] Mon, 01 October 2007 00:59 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
insert into table_name select ....

Is this direct mode insert?

Regards
Michel
Re: how to use remote database data [message #271258 is a reply to message #271235] Mon, 01 October 2007 01:05 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Sorry, conventional Insert operation.
Re: how to use remote database data [message #271260 is a reply to message #271235] Mon, 01 October 2007 01:16 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

OP, you can also use oracle net services to do your task.
Re: how to use remote database data [message #271267 is a reply to message #271235] Mon, 01 October 2007 01:49 Go to previous messageGo to next message
ashish_pass1
Messages: 114
Registered: August 2006
Location: delhi
Senior Member
for your reply

i will do as per your suggestion.
if in case i face any problem i ask .

to all

[mod-edit] removed illiterate IM speak.

[Updated on: Mon, 01 October 2007 07:42] by Moderator

Report message to a moderator

Re: how to use remote database data [message #271272 is a reply to message #271235] Mon, 01 October 2007 02:02 Go to previous message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

thanxx or Thanks!
u or you?
Previous Topic: Getting this ora-06550
Next Topic: Convert BLOB to VARCHAR2
Goto Forum:
  


Current Time: Sun Dec 04 14:21:49 CST 2016

Total time taken to generate the page: 0.09069 seconds