Re: Snapshot fast: what a problem!

Visit Metalink and type the error number in the search field. They have an article listing the most common reasons for fast refresh failures. In the meantime, you might want to change the snapshot from a fast refresh to a FORCE refresh. FORCE performs a FAST refresh if possible and a COMPLETE if not. That way at least the snapshot gets done while you are working on a solution.

In my experience with snapshots, snapshot logs account for the majority of cases where FAST refresh fails. Either they are missing or they have been altered in some way that they become unusable. If a snapshot log is created (or recreated) after the snapshot, a COMPLETE refresh is necessary before FAST can be used.

--
Dave A


"NetComrade" <andreyNSPAM_at_bookexchange.net> wrote in message
news:3a06f68c.441555242_at_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