snor | A very lightweight sickbeard for torrents

I don't think that's possible, check General Restrictions on Fast Refresh

The defining query of the materialized view is restricted as follows:

• The materialized view must not contain references to non-repeating expressions like SYSDATE and ROWNUM.

• The materialized view must not contain references to RAW or LONG RAW data types.

• It cannot contain a SELECT list subquery.

• It cannot contain analytic functions (for example, RANK) in the SELECT clause.

• It cannot reference a table on which an XMLIndex index is defined.

• It cannot contain a MODEL clause.

• It cannot contain a HAVING clause with a subquery.

• It cannot contain nested queries that have ANY, ALL, or NOT EXISTS.

• It cannot contain a [START WITH …] CONNECT BY clause.

• It cannot contain multiple detail tables at different sites.

• ON COMMIT materialized views cannot have remote detail tables.

• Nested materialized views must have a join or aggregate.

• Materialized join views and materialized aggregate views with a GROUP BY clause cannot select from an index-organized table.