Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: snapshot

Re: snapshot

From: Erich <ese_at_ozemail.com.au>
Date: 2000/03/15
Message-ID: <8gHz4.47811$3b6.201645@ozemail.com.au>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US