| 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.
|
|
|
| Re: Alter Materialized View from Complete to Fast [message #291445 is a reply to message #291442 ] |
Fri, 04 January 2008 04:29  |
Michel Cadot
Messages: 17697
Registered: March 2007
Location: Nanterre, France, http://... |
Senior Member |
|
|
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 |
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 |
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 |
Michel Cadot
Messages: 17697
Registered: March 2007
Location: Nanterre, France, http://... |
Senior Member |
|
|
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 |
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 |
Michel Cadot
Messages: 17697
Registered: March 2007
Location: Nanterre, France, http://... |
Senior Member |
|
|
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
|
|
|
]
Members
Search
Help
Register
Login
Home
