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.
Check this thread on this issue:
Life is a journey, not a destination!
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 :
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@example.com
ROhit Nirkhe,Oracle DBA,OCP
Click Here to Expand Forum to Full Width