Can replication be used to append to a materialized view instead of refresh [message #75307] |
Mon, 06 January 2003 11:28 |
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 |
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.
|
|
|