Re: Replication from 7.3: Master site will upgrade to 8i tomorrow

Re: complete refreshes working after the upgrade -- I don't see a reason why not.
Although .. why don't you rebuild them with PK .. right after the upgrade? Why would you want to go with
complete refreshes for even a week? That does not make *any* sense.

Also, make sure that once you rebuild your snapshots, that it does show up in the master sites
user_registered_snapshots view (I might have got that name slightly wrong) ...
I've been bitten couple of times when snapshots get unregistered and even complete refreshes
fail to register them.

BTW: The only case we have of different versions being in master/snapshot ... is 9.2.0.3 master
with 8.1.7.4 snapshot (nested). Not that it is anywhere close to your setup.

HTH Anurag

"Paul Brewer" <paul_at_paul.brewers.org.uk> wrote in message news:3eea51fd_1_at_mk-nntp-1.news.uk.worldonline.com...
> Sorry for this; we've tried metalink searches, and we've called support,
but
> we can't get a definitive answer, so if anyone here can offer advice, it
> will be more than welcome.
>
> We are replicating (simple read only) from a 7.3.4 database into an 8.1.6
> database - fast refresh with rowid (this by the way is across the
Atlantic).
> No problems up to now.
>
> The owners of the master site have suddenly anounced that tomorrow they
are
> going to upgrade to 8i (I am assuming 8.1.7.4). We have *no* control over
> this.
>
> When the owners of the master site upgrade, they will at the same time
drop
> all their rowid snapshot logs, and create new ones with primary key.
>
> In due course, we will drop and recreate our snapshots with primary key,
and
> everything should be hunky dory (Richard?) but we would prefer to avoid
> doing that in production right now - waiting a week would give us some
space
> just to prove it in a pre-production environment and to get the scripts
> ready...
>
> Of course, our fast refreshes won't work until we do, but we can live with
> complete refreshes for a week; so my question is this:
>
> Will complete refreshes work OK, or will we have an exception due to the
> change in size of the rowid column when the master site upgrades? IIRC,
the
> rowid increases in length when upgrading from 7 to 8, and of course our
> existing 8i snapshots include the M_ROW$$ column.
>
> Any input will be appreciated. In any event we will find out on Sunday
> morning; I will post results.
>
> Regards,
> Paul
>
>
>
Received on Sat Jun 14 2003 - 10:13:55 CDT