| Refresh Completed or Not [message #276147] |
Wed, 24 October 2007 02:12  |
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
|
Senior Member |
 
|
|
Hi,
I done advanced replication in oracle 9i. Daily we need to transfer data to materialized view site.
There is no problem in data transferring. But once complete data transfer i check v$mvrefresh table. Only one object always showing.
I checked that object in mater and materialized view site it's valid and that object exits in master group, replication object and refresh group also. Even there is no error msg appearing.
May i know reason. Once complete data transfer, Always why waiting particular objects in v$mvrefresh.
Oracle Saying..
1. If a fast refresh was succeeding but then fails, then check whether:
The materialized view log was truncated, purged, or dropped.
You still have the required privileges on the materialized view log.
2. If a force refresh takes an inordinately long time, then check if the materialized view log used by the refresh has been dropped.
Both condition working well. there is no problem. Any thing else ??
[Updated on: Thu, 25 October 2007 01:33] Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
