Re: snapshot

Erich wrote:
>
> 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

Have you got a snapshot log for the snapshot? If not, you can't use the fast refresh.

Regards.

-- 
Julio Negueruela

'Hay algunas cosas que son tan serias 
que solo puedes bromear con ellas.' (Bohr)