Posted by: michaelverzijl | 15/10/2011

Materialized views with GoldenGate

If your source system has materialized views, please pay attention to the following:

Limitations of support for materialized views (MVs)
● 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.
● Full refreshes are supported for Oracle 10g and later.

A solution is to change the materialized views “FOR UPDATE” before replicating this table.

If you don’t do this REPLICAT will abend with this message:

2011-10-15 21:14:44  WARNING OGG-00869  OCI Error ORA-01732: data manipulation operation not legal on this view (status = 1732), SQL <INSERT INTO "SCHEMA_TAR"."MV_TABEL" ("ID","STR","DATUM") VALUES (:a0,:a1,:a2)>.

You can also enable DDL support and exclude the SNAPSHOTS (if they are in your mapping):

DDL INCLUDE all, EXCLUDE OBJTYPE 'SNAPSHOT'
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Categories

%d bloggers like this: