how can i refresh a snapshot

[fmedina]

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.

[sambavan]

Check this thread on this issue:

[url]http://www.dbasupport.com/forums/showthread.php?threadid=6625[/url]

Sam

[rohitsn]

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