| Snapshot not updating problem ..? [message #74981] |
Sat, 06 January 2001 05:46  |
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  |
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
----------------------------------------------------------------------
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
