Home » Server Options » Replication » Snapshot not updating problem ..?
Snapshot not updating problem ..? [message #74981] Sat, 06 January 2001 05:46 Go to next message
Raghu
Messages: 31
Registered: September 2000
Member
Hi all,

I have some problem in updateable snapshots.

I have 2 databases say DB1 & DB2. I have a table say "emp" at DB1 & I have a fast snapshot log created for that. In DB2 I have created a updateable snapshot say "snp_emp". Also I have created a snapshot group "test_group" & added snapshot "snp_emp" to this group. But the problem is, When I Update the snapshot "snp_emp" it is not reflecting in DB1 s "emp" table, also after the snapshot refresh time "snp_emp" is refreshed by snpshot log of "emp" so that whatever i have updated in "snp_emp" is rolling back. In fact i have also commited after update.

I'm Using ORACLE 8.1.5 on Red hat linux 6.1.

Thanks in Advance

Raghavendra M.K.

----------------------------------------------------------------------
Re: Snapshot not updating problem ..? [message #74989 is a reply to message #74981] Tue, 23 January 2001 07:36 Go to previous message
Eddie
Messages: 23
Registered: January 2001
Junior Member
Hi,

Check if after commiting on the snapshot site a defer transaction appear in the defered transactions queue. Try to run the refresh job manually:

connect repadmin/repadmin_pass
begin
dbms_job.run(job_id);
end;
/

Look for error transactions on the master site:

SELECT * FROM DEFERROR;

Regards,
Eddie

----------------------------------------------------------------------
Previous Topic: cannot insert from remote db
Next Topic: snapshot using rowid
Goto Forum:
  


Current Time: Fri Mar 29 05:08:37 CDT 2024