Update snapshots after altering table definition?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Update snapshots after altering table definition?

  1. #1
    Join Date
    May 2000
    Huntsville, AL. USA
    I am running Oracle 8.1.6 and am replicating to one other server. We want to update some column widths in some tables on the master server and I understand this will require doing the same on the server I am replicating to to keep the schema definitions identical. What I am concerned about, is do I need to also update/drop/recreate the snapshots? Also, are there other steps that I need to be aware of before doing this?

  2. #2
    Join Date
    Jun 2001
    Helsinki. Finland
    I have had and still have exactly the same problem. What I do is, if a new colum is added to a table of the master site, I drop and recreate the materialized view at the replication side. It takes a couple of minutes to do that and columns are actually added not every day, so that's the way I solve that problem.

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