Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Fast Refresh of Snapshots When Database Link Connects to Account
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