Home » SQL & PL/SQL » SQL & PL/SQL » Delta Refresh and Full Refresh?
Delta Refresh and Full Refresh? [message #194158] Thu, 21 September 2006 01:25 Go to next message
gowthamsen
Messages: 14
Registered: August 2006
Junior Member
Hi,

Could anyone please explain about Delta Refresh and Full Refresh?

Thanks and regards
Gowtham Sen.
Re: Delta Refresh and Full Refresh? [message #194203 is a reply to message #194158] Thu, 21 September 2006 03:04 Go to previous messageGo to next message
kimant
Messages: 201
Registered: August 2006
Location: Denmark
Senior Member
I guess You are talking about replication/Materialized views?

Complete refresh truncates the MV and then loads all rows again.
Fast refresh checks the log(s) and then deletes/loads according to the changes recorded in the log(s).
Re: Delta Refresh and Full Refresh? [message #194212 is a reply to message #194203] Thu, 21 September 2006 03:41 Go to previous messageGo to next message
gowthamsen
Messages: 14
Registered: August 2006
Junior Member
Thank you Kimant.

As you said if the source and destination are in the same database then its good.

But My scenario is, I am building a Data Warehouse. For that I need to extract data from different sources to Data warehouse. At that time, in real time, we scan only the records which are updated. I would like to know, the concetpt wise and I am looking for the ways to implement those techniques.

Thanks and regards
Gowtham Sen.
Re: Delta Refresh and Full Refresh? [message #194213 is a reply to message #194212] Thu, 21 September 2006 03:49 Go to previous messageGo to next message
kimant
Messages: 201
Registered: August 2006
Location: Denmark
Senior Member
I did not say that both origin table(s) and resulting MV needs to reside in the same database.

This is not a simple task, as there are quite a few tasks that needs to be done correctly.

You really need to look into the documentation.
There You will find many examples etc., for just what You need.
Re: Delta Refresh and Full Refresh? [message #194221 is a reply to message #194213] Thu, 21 September 2006 04:07 Go to previous messageGo to next message
gowthamsen
Messages: 14
Registered: August 2006
Junior Member
Thank you very much for your suggesiton, Kimanth.

Could you please provide any document link, that can help me out of this problem.

Thanks and regards
Gowtham Sen.
Re: Delta Refresh and Full Refresh? [message #194222 is a reply to message #194221] Thu, 21 September 2006 04:10 Go to previous messageGo to next message
kimant
Messages: 201
Registered: August 2006
Location: Denmark
Senior Member
Go to otn.oracle.com
Click Documentation > index
Select <Your version>
select "View library"
Search for
replication
materialized view
etc.
Re: Delta Refresh and Full Refresh? [message #194225 is a reply to message #194222] Thu, 21 September 2006 04:18 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Or go to http://tahiti.oracle.com/, pick your release and browse away.
Re: Delta Refresh and Full Refresh? [message #194243 is a reply to message #194222] Thu, 21 September 2006 05:07 Go to previous messageGo to next message
gowthamsen
Messages: 14
Registered: August 2006
Junior Member
Thank you Kimanth.

Thanks and regards
gowtham sen.
Re: Delta Refresh and Full Refresh? [message #194389 is a reply to message #194243] Thu, 21 September 2006 20:42 Go to previous message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
Take a look at Change Data Capture in the Data Warehousing Guide.

There is a great new feature available in 10g that does exactly what you want without using MVs.

Ross Leishman
Previous Topic: Trigger and event code.
Next Topic: sum of the range
Goto Forum:
  


Current Time: Fri Dec 09 11:55:30 CST 2016

Total time taken to generate the page: 0.11746 seconds