Re: Snapshot fast: what a problem!

From: NetComrade <andreyNSPAM_at_bookexchange.net>
Date: Mon, 06 Nov 2000 18:20:58 GMT
Message-ID: <3a06f68c.441555242@news.earthlink.net>

have you built a snapshot log on master site? what's the error you are getting?
you can clear broken jobs

On Fri, 03 Nov 2000 21:45:22 GMT, "Antonio Sant" <asant_at_iol.it> wrote:

>Hi there!
>
>Here is a problem that I'm having with Oracle's snapshots, version 7.3.
>
>I've got a table of 300,000 rows, and I must do a snapshot of it. As the
>table is very static (eg.: once a mounth some row, 10 to 300, change) I made
>a fast snapshot using db-link (different db-istance).
>
>But there is a problem, from time to time the refresh I can't do a fast
>refresh (I get an Oracle error and if I don't do something the job that
>refresh the table broke!).
>
>The only way that I know is to do a full refresh!
>
>What's going on?
>
>I've talk with some dba, they say it's strange but no one give me a tip!
>
>Any suggestion?
>
>Thak you.
>
>

---

In case I forgot to mention:
We use Oracle 7.3.4 and 8.1.6 on Solaris 2.6, 2.7 boxes

---

Andrey Dmitriev	 eFax: (978) 383-5892  Daytime: (917) 750-3630
AOL: NetComrade	 ICQ: 11340726 remove NSPAM to email

Received on Mon Nov 06 2000 - 12:20:58 CST