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

Thread: Problems with snapshots refresh

  1. 06-26-2001, 09:49 AM #1
    siroracle
    siroracle is offline Junior Member
    Join Date
    Sep 2000
    Posts
    78

    Arrow

    Hi,

    I like to make replication from one DB schema to another so that in the other schema I will have only a subset of the tables rows. I made snapshot in the new schema that selects the rows needed from the table in the other schema. It created ok, but it cannot refresh (it says 'table or view not found'). The weird things is that it works for one snapshot and it doesn't work for others.

    I have Oracle 8.1.5.0.0 Standard Ed. under WinNT

    Thanx!
    Reply With Quote Reply With Quote
  2. 06-26-2001, 10:17 AM #2
    jm
    jm is offline Member
    Join Date
    Nov 2000
    Posts
    245

    try to manually refresh, it not work, you have to recreate the snapshot
    Reply With Quote Reply With Quote
  3. 06-26-2001, 10:29 AM #3
    siroracle
    siroracle is offline Junior Member
    Join Date
    Sep 2000
    Posts
    78
    I succeddes to refresh them, but only refresh complete.
    Reply With Quote Reply With Quote
  4. 06-26-2001, 02:49 PM #4
    msuresh
    msuresh is offline Member
    Join Date
    Jun 2000
    Location
    chennai,tamil nadu,india
    Posts
    159
    Do Alter system flush shared_pool and try for auto refresh.I think it should work
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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