RE: [Replication] Altering Master Object at materialized view replication environment

Hello!

> That's one of the nuances of MV replication. If you alter the master
table,
> you have to drop and recreate the MV on the snapshot site. This is as
per Oracle's internal documentation.

:-(

> However, there is a trick. If you have created the MV using a prebuilt
> table, then you can have a workaround.

[ ... ]

> Of course, there are several small but crucial steps to be followed. I
have
> described the procedure completely in

http://www.dbazine.com/nanda2.html .
> Hope this helps.

Thank you, it works.
But it's reasonable only if a table size is huge ... or channel capacity is small :-), so complete refresh becoms very expensive operation ...

/sds

PS: About " http://www.dbazine.com/nanda2.html ", imho, something wrong in this sentence:
"The table has two columns, COL1 NUMBER (9) and COL2 CHAR(1000), COL3 CHAR(900)" ... 8-)

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Dennis Sorokin
  INET: sds_at_ru.ru

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).