Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Snapshots with Huge Data...
Sorry, in between the holidays and all I haven't been
keeping up with my digests. So I don't know if anyone
has replied to your email.
In case they haven't....
Yes, in short the import will not help you one little bit. You've got to do a complete refresh or recreate the snapshot, which would do a refresh anyhow.
Leng - lkaing_at_yahoo.com
From: "Kamalakannan, D (CAP, GCF)"
Date: Tue, 2 Jan 2001 13:09:46 +0100
Subject: RE: Snapshots with Huge Data...
This means that there is no necessity for importing
the data since a
complete refresh will take a lot of time and it will
not help the original
cause for importing.This way of implementing the
snapshots is not right for
the original cause ?
Correct me if I am wrong !
Kamal
-----Original Message-----
Sent: Sunday, December 31, 2000 9:15 PM
To: Multiple recipients of list ORACLE-L
I think that Barry's right. The snapshot logs wouldn't know about the imported tables. Your best shot is to do a complete refresh of the snapshot or increase the refresh interval of your snapshot. This is just one of the pains of snapshots.
Rgs,
Leng - lkaing_at_yahoo.com
![]() |
![]() |