snapshot

From: Erich <ese_at_ozemail.com.au>
Date: 2000/03/12
Message-ID: <SpKy4.45642$3b6.195203@ozemail.com.au>#1/1

Using Oracle 7.3.4, created a snapshot between to databases on different servers (NT4). Created the snapshot with fast refresh. Also created snapshot log on the master table.

When trying to refesh, get the following error message:

ERROR at line 1:

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

If I change to "refresh complete" everything works. The snapshot is a very simple one, using a trial database with only a few records.

Any suggestions would be appreciated.

Erich Received on Sun Mar 12 2000 - 00:00:00 CST