Re: Fast Refresh of Snapshots When Database Link Connects to Account

Ian,

Don't quote me at the moment (I'm coming off of a 12 hour day), but try using <owner.tablename> in the create snapshot statement. I seem to remember having to do this along with the USING ROWID clause replicating from 7.3 to 8.0

YMMV, Scott

• Original Message ----- From: "MacGregor, Ian A." <ian_at_SLAC.Stanford.EDU> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Wednesday, June 28, 2000 1:43 PM Subject: 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
> --
> Author: MacGregor, Ian A.
> INET: ian_at_SLAC.Stanford.EDU
>
> 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 Wed Jun 28 2000 - 19:37:18 CDT