Home » Server Options » Replication » Alter Materialized View from Complete to Fast (Oracle,9.2.0.8,Solaris 9)
Alter Materialized View from Complete to Fast [message #291442] Fri, 04 January 2008 04:10 Go to next message
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.
Re: Alter Materialized View from Complete to Fast [message #291445 is a reply to message #291442] Fri, 04 January 2008 04:29 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can't fast refresh without mview log.

Regards
Michel
Re: Alter Materialized View from Complete to Fast [message #291448 is a reply to message #291445] Fri, 04 January 2008 04:36 Go to previous messageGo to next message
vishal_srivastava
Messages: 21
Registered: January 2008
Junior Member
So i have to create MVIEW log for all the tables refrenced in MVIEW creation?
Re: Alter Materialized View from Complete to Fast [message #291449 is a reply to message #291445] Fri, 04 January 2008 04:39 Go to previous messageGo to next message
vishal_srivastava
Messages: 21
Registered: January 2008
Junior Member
Kindly suggest me the STEPS to alter this snapshot.
Re: Alter Materialized View from Complete to Fast [message #291453 is a reply to message #291449] Fri, 04 January 2008 04:51 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
drop mview
create mview log
create mview log
create mview log
create mview log
create mview

Regards
Michel
Re: Alter Materialized View from Complete to Fast [message #294847 is a reply to message #291442] Sun, 20 January 2008 02:13 Go to previous messageGo to next message
mujeeb_andeth
Messages: 2
Registered: January 2008
Junior Member
Hello,
The syntax to change the refresh method from complete to fast

is
ALTER SNAPSHOT <name> refresh fast;

Thanks
Mujeeb
Re: Alter Materialized View from Complete to Fast [message #294849 is a reply to message #294847] Sun, 20 January 2008 02:21 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Not really a good way to do it as Oracle does not make the verification it does on create materialized view and so you can think it will work when it actually will not.

Regards
Michel
Previous Topic: Error while creating MV replication group object
Next Topic: Help to reproduce error
Goto Forum:
  


Current Time: Fri Mar 29 04:16:23 CDT 2024