Headache Problem In Material View ( MV) refresh
Very Headache Problem .
We got 2 database server . Live server and report server .
the report server is using MV to get the data from Life server .
the refresh mode is 'F' .
There is some housekeeping batch running in life server .
BUt actually , no data is purged because there is no 'old enough
data' in life server . So when the housekeeping procedure running ,
actually the delete statement is not purging anything .
the funny things is although there is nothing deleted in life server , the MV refresh report server is hanging ! it simply executing for ever !
Is there any thoughts to figure out what is the problem ?
Oracle Database is 9.2.0.1.0 in unix .
1. www.dbasupport.com
2. www.dbforums.com
3. www.itpub.net
4. www.csdn.net
5. www.umlchina.com
6. www.tek-tips.com
7. www.cnforyou.com
8. fm365.federal.com.cn
9. www.programmersheaven.com
10.http://msdn.microsoft.com/library/default.asp
ligang1000@hotmail.com