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: 229
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
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: 26766
Registered: January 2009
Location: SoCal
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.
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: 229
Registered: May 2006
Location: Mumbai
Senior Member

Hi BlackSwan,
Please let me know what is meant by "Change Data Capture".


Regards,
Mona
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: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
http://www.oracle.com/pls/db102/search?remark=quick_search&word=Change+Data+Capture&tab_id=&format=ranked

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


Current Time: Fri Mar 29 05:10:50 CDT 2024