Members   Search   Help    Register    Login   Home
Home » Other » General » Update master table with changes only (Oracle 10g)
Update master table with changes only [message #424684] Mon, 05 October 2009 05:53 Go to next message
monasingh
Messages: 207
Registered: May 2006
Location: Mumbai
Senior Member
Hi,
We have an ERP aplication from where we'll be getting some data in some tables to be pushed into another set of tables in a seperate database which would be used mainly for reporting.

The data would be populated in some parking tables in 24 hour intervals. There would be some transaction tables as well as Master tables.

We need to update our reporting database with the DML operations done in the ERP database via the parking tables.

For the master tables...there won't be much changes everyday...may be some additions and some updations. What is the best way to do this activity.

Regards,
Mona
Report message to a moderator
Re: Update master table with changes only [message #424720 is a reply to message #424684] Mon, 05 October 2009 10:22 Go to previous messageGo to next message
BlackSwan
Messages: 3357
Registered: January 2009
Senior Member
>What is the best way to do this activity.
Best is difficult to define.
One way would be to use Change Data Capture.
Report message to a moderator
Re: Update master table with changes only [message #424764 is a reply to message #424720] Mon, 05 October 2009 23:11 Go to previous messageGo to next message
monasingh
Messages: 207
Registered: May 2006
Location: Mumbai
Senior Member
Hi BlackSwan,
Please let me know what is meant by "Change Data Capture".


Regards,
Mona
Report message to a moderator
Re: Update master table with changes only [message #424768 is a reply to message #424764] Mon, 05 October 2009 23:25 Go to previous message
Michel Cadot
Messages: 29419
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
http://www.oracle.com/pls/db102/search?remark=quick_search&word=Change+Data+Capture&tab_id=&format=ranked

Regards
Michel
Report message to a moderator
Previous Topic:steps to create SR in Metalink
Next Topic:Oracle database database backuu
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Nov 30 18:44:22 CST 2009

Total time taken to generate the page: 0.53021 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.