Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: snapshot
Yes, I have a snapshot log.
Erich
Julio wrote in message <38CCD56B.2DE1B7CC_at_si.unirioja.es>...
>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)
Received on Wed Mar 15 2000 - 00:00:00 CST
![]() |
![]() |