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 [email protected]
regards,
ROhit Nirkhe,Oracle DBA,OCP