Hi,

What is the best way of estimating the size for a MV before it's creation

I have to create an MV of a table located on remote database
which will be an exact replica of the master table (all columns)
with a fast refresh.

I have tried using the dbms_olap.est_mview_size pkg
but it does not give me any value

Thnx in advance