Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Drop Snapshot

505453Aug 26 2009 — edited Sep 12 2009

Hello Folks,

DB :10.2.0.4
OS : Aix 5.3

I have a snapshot replication from source to target. And it's getting refreshed through refresh group. i would like to remove some of the tables from replication group. I am planning to follow below sequence.

1> Extract SQL’s before dropping.. from source and target.
2> Stop refresh wrapper
3> Subtract snapshot from refresh group. (DBMS_REFRESH.SUBTRACT)
4> Drop mv on snapshot site. ( drop mv <> ; )
5> Rename the table for later drop
5> Drop mv log on master site. ( drop mv log on <table-name> ; )

Is that a right sequence ? Any suggestions?

Thanks for your time.

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 10 2009

Added on Aug 26 2009

#database-key-features, #replication

3 comments

3,807 views