This discussion is archived
2 Replies Latest reply: Jul 30, 2013 10:32 AM by stevencallan RSS

Replication of MViews in Golden gate

Andy.....! Newbie
Currently Being Moderated

Hi All,

 

Source : DB version 10.2.0.4 Windows

Target : DB version 11.2.0.2.10 on linux

 

I am doing golden gate bidirectional configuration from 10g windows to 11g linux RAC.

I am doing schema level bidirectional configuration using "ADD TRANDATA" (schema_name.*)


In this configuration materialized views will replicate?

 

In fact, I don't want to replicate MViews.

 

Kindly suggest...

 

Regards,

Andy.

  • 1. Re: Replication of MViews in Golden gate
    marie.couch Explorer
    Currently Being Moderated

    Andy,

     

    Yes, since materialized views are one of the object types that can be specified with the TABLE parameter, if the materialized view name matches the SCHEMA.* wildcard, it will be captured by Extract. If you want them excluded, you could use the TABLEEXCLUDE parameter to filter them out.

     

    Best regards,

    Marie

  • 2. Re: Replication of MViews in Golden gate
    stevencallan Expert
    Currently Being Moderated

    Umm, not necessarily. There are a lot of determining factors as to whether or not an MV will be replicated.

     

    1.6.1.4 Limitations of support for materialized views

    These limitations apply to integrated and classic capture modes.

    ■ Materialized views created WITH ROWID are not supported.

    ■ The materialized view log can be created WITH ROWID.

    ■ The source table must have a primary key.

    ■ Truncates of materialized views are not supported. You can use a DELETE FROM

    statement.

    ■ Some Oracle GoldenGate initial-load methods do not support LOBs in a

    materialized view.

    ■ For Replicat, the materialized view must be updateable.

    ■ DML (but not DDL) from a full refresh of a materialized view is supported. If DDL

    support for this feature is required, open an Oracle GoldenGate support case

     

    Do an explicit extract (list exactly what you want to have replicated), or make sure you exclude them by name.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points