Re: ORA-01555 on source database for materialized view refresh across link

Daniel Fink wrote:

>About 60 minutes before the mv refresh, I performed a fts query against
>each table. No errors on the query.

Just want to be sure everyone understands this fts is to _fix_ the dbc by cleaning out buffers, not show evidence of it. So if you want to use it to fix the problem, perhaps you should run it just after the MV refresh completes

Metalink Note: 40689.1 and http://www.jlcomp.demon.co.uk/cleanout.html and especially
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:7705505116425 are good explanations of dbc. Note the bit about looking at v$transaction to see how much and how long.

jg

-- 
@home.com is bogus.
http://www.monobrow.com/monobro/