Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Fast Refresh of Snapshots When Database Link Connects to Account

Fast Refresh of Snapshots When Database Link Connects to Account

From: MacGregor, Ian A. <ian_at_SLAC.Stanford.EDU>
Date: Wed, 28 Jun 2000 10:30:54 -0700
Message-Id: <10542.110690@fatcity.com>


I would have sworn one could perform fast refreshes of snapshots when the database link connects to an account different from the owner of the table to be snapshotted and the owner of the table's snapshot_log. If the account to which you are connecting has select privileges on both the table to be snapshotted and the snapshot_logs and synonyms are properly in place. Alas, this does not appear to be the case; alack, complete refreshes will be done. Unless, it is a lack of a complete understanding of the steps involved to do this.

Ian MacGregor
Stanford Linear Accelerator Center
ian_at_slac.stanford.edu Received on Wed Jun 28 2000 - 12:30:54 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US