Actually data consists in the base table is 100 millions and its single table aggregate MView.

Any suggestions, how to reduce the MView eats up lots of space in temporary tablespace.

Thanks in advance.
Sarav.