Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Snapshot fast: what a problem!
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