hi all
i have oracle 7.3.4 installed, i have replication between some databases, a snapshot have tree days that it don't refresh and update the data, how can i refresh manually.
F.m.v.
Printable View
hi all
i have oracle 7.3.4 installed, i have replication between some databases, a snapshot have tree days that it don't refresh and update the data, how can i refresh manually.
F.m.v.
Check this thread on this issue:
http://www.dbasupport.com/forums/sho...?threadid=6625
Sam
Hi,
In order to refresh snapshot manually u have to install dbms_snapshot package under SYS schema.In order to create the package run dbmssnap.sql in ur SYS schema.Then u can manually refresh the snapshot.There are many procedures in that package which u can use to refresh the snapshots.Example of manually refreshing a snapshot is give below :
exec sys.dbms_snapshot.refresh('SCOTT.EMPSNAP','C');
The above command will manually refresh the empsnap snapshot in scott schema which was designed for complete refresh.
If any help wanted please be free to write to me at rohitsn@altavista.com
regards,
ROhit Nirkhe,Oracle DBA,OCP