Home » RDBMS Server » Server Utilities » Update Remote Databases
Update Remote Databases [message #222841] Tue, 06 March 2007 11:42 Go to next message
jayoung
Messages: 21
Registered: October 2005
Location: USA
Junior Member
I have several remote database that need to have one table updated from a master table in our main office on a nightly basis does anyone here have any ideas or suggestions on how to do this?


Jay
Re: Update Remote Databases [message #222845 is a reply to message #222841] Tue, 06 March 2007 12:11 Go to previous messageGo to next message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
Sounds like a perfect scenario for materialized views.
Re: Update Remote Databases [message #222881 is a reply to message #222845] Tue, 06 March 2007 17:34 Go to previous messageGo to next message
jayoung
Messages: 21
Registered: October 2005
Location: USA
Junior Member
if i use Materialized Views and changes are made to the master table say one or 2 rows change how does it send just those row updates and not the whole table? and how do you schedule these jobs or update?


Jay
Re: Update Remote Databases [message #222929 is a reply to message #222881] Wed, 07 March 2007 00:14 Go to previous messageGo to next message
Littlefoot
Messages: 21813
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
It is all in the documentation.
Re: Update Remote Databases [message #223127 is a reply to message #222841] Wed, 07 March 2007 12:38 Go to previous message
jayoung
Messages: 21
Registered: October 2005
Location: USA
Junior Member
I started reading the doc got it almost setup thanks.
Previous Topic: imp / exp problem with sequence no
Next Topic: IMP-00017:
Goto Forum:
  


Current Time: Tue Jul 02 16:13:55 CDT 2024