creating MV logs in a logical standby DB

From: Ora_DBA <sanjaydharmadhikari_at_gmail.com>
Date: Thu, 9 Dec 2010 17:22:47 -0800 (PST)
Message-ID: <de9a7f2d-f838-4a1b-8ca2-0ae8bdc8f2d4_at_p11g2000vbn.googlegroups.com>



I am trying to create materialized views based on a few tables in a logical standby database.

The target database (11g R2) where the MVs will be created is a standalone  database.

The DB where the base tables reside is a logical standby database (11g R2).

The requirement is to do a "FAST REFRESH" of the Materialized Views.

My questions are :

  1. Can I create MV logs in the logical standby DB?
  2. If the answer to question no. 1 is "Yes", do I need to do anything different or configure the logical standby DB in a specific manner in order to create MV logs. From what I understand, the objects in the logical standby database are in a locked state. Is that going to be a problem ?

Any other information that might be relevant is greatly appreciated.

Thanks in advance. Received on Thu Dec 09 2010 - 19:22:47 CST

Original text of this message