Home » Server Options » Replication » Can replication be used to append to a materialized view instead of refresh
Can replication be used to append to a materialized view instead of refresh [message #75307] Mon, 06 January 2003 11:28 Go to next message
Majid Hosseini
Messages: 1
Registered: January 2003
Junior Member
Hi,

Does any one know if oracle replecation can be configured such that instead of refreshing a materialized view, just append the new inserts/updates to it. This is the problem that I have:
I need a log data base that needs to record everything
(any insert/delete/update) that happens at the master
data base. Can replication be used for this?
Re: Can replication be used to append to a materialized view instead of refresh [message #75324 is a reply to message #75307] Tue, 18 February 2003 08:20 Go to previous message
SIMONA
Messages: 3
Registered: February 2003
Junior Member
If you want the replication in real time you must user the materialized view with REFRESH FAST ON COMMIT.
The REFRESH FAST is possibile only with a materialized view with materialized log. Is possibile to create a materialized view log with a non complecated query.
If your materialized view is made with a complicated query you have COPLETE MATERIALIZED VIEW that for first time delete all rows and then re-populate the materialized view and naturally use a temporal refresh.
Previous Topic: How to replicate the full schema?
Next Topic: Fast refresh on Materialized view
Goto Forum:
  


Current Time: Thu Mar 28 11:24:48 CDT 2024