0 Replies Latest reply: Feb 23, 2013 10:36 AM by 905989 RSS

    impact of a new record on primary on Materiaslised view on replicate


      We are just refreshing completely the MV on replicate based on primary table at source

      It is a large table with 54GB of data to be synched. There are more indexes on replicated (used for reporting) thast the source.

      Data has completed on MV sync and now doing indexes (10th out of 18). So indexes are being synched now no data.

      If we add a record to source table will that have any negative impact on MV sync of inderxes? My understang is that MV will sync data in the next refresh and will use undo informatyion at the source if needed?

      Please advise.


      Edited by: 902986 on 23-Feb-2013 08:35