RE: Fast Refresh of Snapshots When Database Link Connects to Acc ount

Thanks! Fully qualifying the table to snapshotted; i.e., using <owner>.<table_name> did the trick.

Ian

-----Original Message-----
From: Scott Shafer [mailto:scott.shafer_at_ildmail.com] Sent: Wednesday, June 28, 2000 6:35 PM
To: Multiple recipients of list ORACLE-L Subject: 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 ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Wednesday, June 28, 2000 1:43 PM

> 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).

-- 
Author: Scott Shafer
  INET: scott.shafer_at_ildmail.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).