Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Snapshot fast: what a problem!
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.
>
>
Andrey Dmitriev eFax: (978) 383-5892 Daytime: (917) 750-3630 AOL: NetComrade ICQ: 11340726 remove NSPAM to emailReceived on Mon Nov 06 2000 - 12:20:58 CST
![]() |
![]() |