| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> FW: Snapshots with Huge Data...
Why would this work ?
A fast refresh depends on the data in the snapshot
logs at the remote site. In this scenario the logs
should indicate that all rows need to refresh ??
Barry
-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com] On Behalf Of Bala, Prakash Sent: Monday, December 04, 2000 2:26 PM To: Multiple recipients of list ORACLE-L Subject: RE: Snapshots with Huge Data...
Yes, your idea will work.
Prakash
-----Original Message-----
Sent: Sunday, December 03, 2000 3:00 PM
To: Multiple recipients of list ORACLE-L
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>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bala, Prakash
INET: Prakash_Bala_at_bscc.bls.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Sat Dec 30 2000 - 18:10:49 CST
 |
 |