Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

[b]Updating table fields with data from another database [/b]

Status
Not open for further replies.
tatochka

tatochka

Programmer
May 3, 2001
49
0
0
US
I have 2 Oracle 9i databases. One is test & one is production. I'd like to write a script that will let me to update production table with data from test table. Not all fields have to be updated. Is it possible in one script?
 
Sort by date Sort by votes
create a database link. U can then select/update any needed from one to the other
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

deo1
  • Locked
  • Question
Please help with forms6i ole2 ms word
Replies
0
Views
69
deo1
deo1
BJCooperIT
  • Locked
  • Question
Problem running a form from Forms Builder
Replies
2
Views
88
BJCooperIT
BJCooperIT
faizsaadq
  • Locked
  • Question
How to call crystal reports XI from Oracle Forms 10G
Replies
1
Views
82
oradba101
oradba101
arznrchrd
  • Locked
  • Question
Navigating Oracle Forms From Another Client???
Replies
0
Views
26
arznrchrd
arznrchrd
taqmeena
  • Locked
  • Question
changing DataBase user in Forms 2
Replies
2
Views
59
lewisp
lewisp

Part and Inventory Search

Sponsor

Back
Top