Snapshots with Huge Data...

From: Ramlal K Chithu <TS2182_at_emirates.com>
Date: Sun, 3 Dec 2000 13:41:23 +0400
Message-Id: <10699.123478@fatcity.com>

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

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2652.35">
<TITLE>Snapshots with Huge Data...</TITLE>
</HEAD>
<BODY>
 

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.
 <A =
HREF=3D"http://www.emirates.com" =
TARGET=3D"_blank">http://www.emirates.com</A> Received on Sun Dec 03 2000 - 03:41:23 CST