FAQ
Hello

How can i replicate DDL on table (modify column for example) in
materialized view replication environment ?
DBMS_REPCAT.ALTER_MASTER_REPOBJECT alter the object, put changes are not
propagated to MV site ...

I try DBMS_REFRESH.REFRESH and DBMS_REPCAT.REFRESH_MVIEW_REPGROUP at MV
site, but I steel don't see the changes.
Is it possible to propagate DDL to MV site ?
Thnx.

/sds

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

Search Discussions

  • Arup Nanda at Jan 15, 2003 at 4:18 pm
    Dennis,

    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. When you build an MV on a table,
    Oracle simply assumes the type of the segment as MV rather than the table,
    i.e. the segment that used to be known as the table is now known as the MV.
    when the MV is dropped, Oracle does not drop the segment; rather it reverts
    the type to the table as it used to be.

    So when you alter the master table, follow the sequence of steps.

    stop replication
    drop the MV
    alter the master table
    alter the prebuilt table in the same way.
    Build the MV on the prebuilt table again.

    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.

    Arup Nanda

    Original Message -----
    To: "Multiple recipients of list ORACLE-L"
    Sent: Tuesday, January 14, 2003 3:53 AM
    replication environment
    Hello

    How can i replicate DDL on table (modify column for example) in
    materialized view replication environment ?
    DBMS_REPCAT.ALTER_MASTER_REPOBJECT alter the object, put changes are not
    propagated to MV site ...

    I try DBMS_REFRESH.REFRESH and DBMS_REPCAT.REFRESH_MVIEW_REPGROUP at MV
    site, but I steel don't see the changes.
    Is it possible to propagate DDL to MV site ?
    Thnx.

    /sds


    --
    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).
  • Dennis Sorokin at Jan 20, 2003 at 2:44 pm
    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).
  • Arup Nanda at Jan 20, 2003 at 3:36 pm
    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"
    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).

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedJan 14, '03 at 8:53a
activeJan 20, '03 at 3:36p
posts4
users2
websiteoracle.com

2 users in discussion

Arup Nanda: 2 posts Dennis Sorokin: 2 posts

People

Translate

site design / logo © 2022 Grokbase