I have a materialized view in a data warehouse.
On the hour, the view is refreshed from production.
The refresh fails on occasion due to ora-1555(snapshot too old), that
occurs in the prod db or source across db links.
I would like to use set transcation and use a large RBS.
How can I accomplish this when the view and refresh exists in one db, but
the db generating the 1555 is across db links and would not benefit from
set transaction as the local rb segments are not the issue.
Hmmmm?
Thanks
--
..
David
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at
http://www.freelists.org/archives/oracle-l/
FAQ is at
http://www.freelists.org/help/fom-serve/cache/1.html
Received on Wed Sep 01 2004 - 19:55:36 CDT
