Re: Updateable Snapshot replication PUSH problem

On 11 May 2004 11:58:53 -0700, chrissirwin_at_yahoo.com (Chris Irwin) wrote:

>Hi,
>
>I am using Oracle 8.1.7 with Updateable snapshot replication. When I
>do a dbms_snapshot.refresh as the repadmin user from the snapshot
>site, the changes I made to the table I am refreshing are not pushed
>to the master site. Also, the update is actually overwritten by the
>value that exists on the master site.
>
>Here is the actual refresh call sql:
>
>EXECUTE dbms_snapshot.refresh('scpa.dag', 'F', NULL, TRUE, TRUE, 1, 0,
>0, TRUE);
>
>
>What table can I look in to see whether or not my update on the
>snapshot site is queued.
>
>I get no errors when I do the refresh.
>
>Thanks,
>
>Chris

snapshots are processed by means of pl/sql jobs dba_jobs reportsthe status of the jobs.
dba_snapshots would also be an obvious candidate

--
Sybrand Bakker, Senior Oracle DBA