RE: Snapshots with Huge Data...

Yes, your idea will work.  

Prakash

-----Original Message-----
From: Ramlal K Chithu [mailto:TS2182_at_emirates.com] Sent: Sunday, December 03, 2000 3:00 PM
To: Multiple recipients of list ORACLE-L Subject: 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 <http://www.emirates.com> Received on Mon Dec 04 2000 - 13:25:13 CST