ORACLE-L [EMAIL PROTECTED]
cc:
Subject:read-only simple snapshot/materialised view refresh
Hello everyone,
We've got read-only primary key snapshots in our 8.1.7.4 databases. 1 master. 1 slave. master and slave are on different servers. Snapshots are refreshed by the FAST method
: Kaing, Leng
Subject: Re: read-only simple snapshot/materialised view refresh
Importance: High
Leng,
You didn't mention the frequency of the refresh.
I also don't see mention of which database is generating
the ora-1555 errors.
Jared
Kaing, Leng [EMAIL
Hello everyone,
We've got read-only primary key snapshots in our 8.1.7.4 databases. 1 master. 1 slave.
master and slave are on different servers. Snapshots are refreshed by the FAST
method using dbms_refresh.refresh. However, do to the extremely high transaction rates
on our database, we're