Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2002
    Posts
    1

    Question Unanswered: Replication question on adding a column

    I'm trying to add a column to a huge table (master and snapshot).
    Apparently Oracle only 'supports' the method of dropping the snapshot and recreating it. Because of the size of this table this is nearly impossible for us to do!
    Does anyone have any workarounds?
    THanks,
    Amy

  2. #2
    Join Date
    Apr 2002
    Location
    California, USA
    Posts
    482

    Cool

    Amy,

    There is no way around it. Every time you make DDL to the master tables you have to first quiesce the replication activity before starting DDL changes. Then you have to recreate the affected snapshots and then to restore the replication process.

    I will happy to hear the opposite proven by example.

    Check the latest Oracle DBA forums at:

    http://www.dbaclick.com/cgi-bin/ib3/ikonboard.cgi

    Hope that helps,


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •