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

Dennis,

I am glad that it worked for you. Of course, it's useful if the table size is big. In case of a small table, you would just drop and recreate the snapshot.

Thanks for pointing out the typo.

Regards,

Arup

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Monday, January 20, 2003 9:44 AM 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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Arup Nanda
  INET: arupnanda_at_hotmail.com

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).