Alter Materialized View from Complete to Fast [message #291442] |
Fri, 04 January 2008 04:10  |
vishal_srivastava
Messages: 21 Registered: January 2008
|
Junior Member |
|
|
I am having two server A and B.B is the replica of A.I have to alter the materialized view of one of the table in server B,of which Master table is in both the servers .I do not have any Materialized view log on both the servers and want to convert the Refresh method from Complete to Fast refresh.
One way of this altration is to create materialized view log on master table.
Suggest me the other method.
|
|
|
|
|
|
|
|
|