rowid invalid when refresh fast a snapshot

From: Raymond Bourges <Raymond.Bourges_at_univ-rennes1.fr>
Date: Wed, 24 Jun 1998 11:28:26 +0200
Message-ID: <6mqgm2$611$1@news.univ-rennes1.fr>

RDBMS Version: 7.1.6
Error Number (if applicable): ORA-01014 Operating System: AIX
Product: RDBMS
Product Version: 7.1.6

Hello,

I have this when I do a refresh fast of a snapshot :

begin dbms_snapshot.refresh
('trav_ext_rvm_res','f'); end;

ERREUR a la ligne 1:
ORA-00604: Une erreur s'est produite au niveau SQL recursif 1

ORA-01410: ROWID invalide
ORA-02063: precedant line de "db link name"
ORA-06512: a "SYS.DBMS_SNAPSHOT", ligne 254
ORA-06512: a "SYS.DBMS_SNAPSHOT", ligne 135
ORA-06512: a ligne 1

(Excuse me. It's in french ;-)

If I do a complete refresh all is OK and the next fast work fine too. But sometime, when I have insert an the master table I think the fast refresh fail.

Could you help me ?

Thanks. Received on Wed Jun 24 1998 - 04:28:26 CDT