Re: Oracle7.3-Oracle8 snapshots

From: bs135993 <didier.barjasse_at_skynet.be>
Date: Sat, 19 Aug 2000 23:55:33 +0200
Message-ID: <399F0255.ABE0AAEF@skynet.be>

That can help you .

MIXED ENVIRONMENT: Oracle7 and Oracle8 where your Master Site is Oracle8 and your Snapshot Site is Oracle7, verify that the snapshot log you created on the Oracle8 Master Site was created with

the ROWID option. If it was created with Primary Key, which is default,

you will still receive an ORA-12004

SQL> select master, rowids, primary_key from user_snapshot_logs;

MASTER ROWIDS PRIMARY_KEY

------ ----------- T1 NO YES

You can drop and recreate the snapshot log or simply alter the snapshot log to also log by rowid.

SQL> alter snapshot log on t1 add rowid;

Snapshot log altered.

SQL> select master, rowids, primary_key from user_snapshot_logs;

MASTER ROWIDS PRIMARY_KEY

------ ----------- T1 YES YES

You will need to perform a COMPLETE refresh of your snapshot after making this change.

Regards

> Hi!
> There are master table and snapshot log in remote database Oracle7.3
> Snapshot (refresh fast with rowid) created in Oracle8
> Where I try to fast refresh this snapshot
>
> dbms_snapshot.refresh('snapshot');
>
> ORA-12004 occur.
>
> It ocurr because of the different ROWID format?
Received on Sat Aug 19 2000 - 16:55:33 CDT