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

does materialized view truncate during a full refresh?

Guess2 Newbie
Currently Being Moderated
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.

Legend

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