3 Replies Latest reply: Jan 11, 2010 8:55 AM by user503699 Branched to a new discussion. RSS

    does materialized view truncate during a full refresh?

    Guess2
      Oracle 10.1.0.3
      solaris 5.1

      We have complex materialized views that cannot be fast refreshed. We are noticing that the segment sizes of our MVs are growing, but the rows size with the MVs are the same. My understanding was that part of the process of a full refresh of a materialized view is that it

      1. truncates the Materialized view
      2. repopulated the materialized view

      is this correct? If this is correct, our segments containing the materialized views should stay relatively the same size if the data does not change that much.