Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Oracle7.3-Oracle8 snapshots

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>

Hi

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

    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

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

Regards

"ጅ‹“Ž„’ ÷. 󍉒‹‰Ž" a écrit :

> 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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US