DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: how can i refresh a snapshot

  1. #1
    Join Date
    Jan 2001
    Posts
    32
    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.

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    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!


  3. #3
    Join Date
    Feb 2001
    Location
    Bombay,India
    Posts
    530
    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
  •  


Click Here to Expand Forum to Full Width