Message-Id: <10699.123478@fatcity.com> From: Ramlal K Chithu Date: Sun, 3 Dec 2000 13:41:23 +0400 Subject: Snapshots with Huge Data... This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C05D0D.329A87C0 Content-Type: text/plain; charset="iso-8859-1" Hello DBAs, How are you doing? Enjoying Weekend .... :-) Okay, Coming to the point.... We are replicating a table from Remote database to local database using Snapshots. Since remote table has huge number of records, instead of replicating initially using Snapshots, we just exported and imported to the local table to avoid network traffic. NOW, we need to implement the Snapshot between these 2 table as Fast Refresh. Is it possible to have a snapshot between the IMPORTED local table to the Remote Table? Will the data be updated(Refreshed) to the local table from the point where we did import? Any Work around please... Thank you very much DBAs Have a nice days... Bye Ramlal Software Consultant Emirates Airlines. http://www.emirates.com ------_=_NextPart_001_01C05D0D.329A87C0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Snapshots with Huge Data...

Hello DBAs,
How are you doing?
Enjoying Weekend .... :-)

Okay, Coming to the point....

We are replicating a table from Remote = database to local database using Snapshots.
Since remote table has huge number of = records, instead of replicating initially using Snapshots, we just = exported and imported to the local table to avoid network = traffic.

NOW, we need to implement the Snapshot = between these 2 table as Fast Refresh.

Is it possible to have a snapshot = between the IMPORTED local table to the Remote Table?
Will the data be updated(Refreshed) = to the local table from the point where we did import?

Any Work around please...

Thank you very much DBAs
Have a nice days...

Bye
Ramlal
Software Consultant
Emirates Airlines.
http://www.emirates.com