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

Home -> Community -> Usenet -> c.d.o.tools -> Snapshot fast: what a problem!

Snapshot fast: what a problem!

From: Antonio Sant <asant_at_iol.it>
Date: Fri, 03 Nov 2000 21:45:22 GMT
Message-ID: <SlGM5.12071$fx4.371627@news.infostrada.it>

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. Received on Fri Nov 03 2000 - 15:45:22 CST

Original text of this message

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