Click here to Skip to main content
15,923,273 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
1. there is a table emp,now we will create snapshot log on it:
SQL>create snapshot log on emp;

2. 
SQL>create snapshot s1_emp as select * from emp

3.
SQL>create snapshot log on s1_emp

4.
SQL>create snapshot s2_emp as select * from s1_emp

5.
SQL>alter snapshot s1_emp refresh fast start with sysdate+1/86400 next sysdate + 1/86400;
SQL>alter snapshot s2_emp refresh fast start with sysdate+1/86400 next sysdate + 1/86400;

6. the all process is emp ---snapshot---> s1_emp ---snapshot---> s2_emp,the refresh is 1s.

7. now we will update the table emp
SQL>update emp set ename='kxf' where empno=7934;

8. the result is the snapshot s1_emp hava bean updated,but the snapshot s2_emp not, why?
Posted
Updated 26-Oct-11 20:55pm
v4

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900