-
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:
[url]http://www.dbasupport.com/forums/showthread.php?threadid=6625[/url]
Sam
Thanx
Sam
Life is a journey, not a destination!
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|