snapshot refresh errors

From: Chuck Hamilton <chuckh_at_ix.netcom.com>
Date: 1995/07/11
Message-ID: <3tuiqb$rpq_at_ixnews2.ix.netcom.com>#1/1

I'm having trouble doing a fast refresh on snapshots. It worked fine until I defragmented the master database by exporting the user that contained the master tables and snapshot logs, dropping that user (with cascade option), recreating the user, and importing him. Now when I try to do a fast refresh I get the following...

ERROR at line 1:

ORA-12004: REFRESH FAST cannot be used
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 248
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 131
ORA-06512: at line 1

What's the problem?

-- 
Chuck Hamilton
chuckh_at_ix.netcom.com

Incoming fire has the right of way!

Received on Tue Jul 11 1995 - 00:00:00 CEST

This message: [ Message body ]
Next message: Billy O'Connor: "Re: oracle price"
Previous message: Rob Zoeteweij: "For S.Muench Oracle Corporation"
Next in thread: Contractor - Yuk Hon : "Re: snapshot refresh errors"
Reply: Contractor - Yuk Hon : "Re: snapshot refresh errors"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message