materialized view. help...

[anna]

Hi all,

I've been digging this problem almost 3 days now.

I created some 'normal' views and then join them all together to
create a materialized view but I got this error message:

"Subquery expressions not allowed here"

I use subqueries *only* in 'normal' views.

any comments, advice really appreciated.

many thanks
anthony

[Daniel Roy]

Re: materialized view. help...

According to what I see in the Data Warehouse manual
(http://download-west.oracle.com/docs...20/mv.htm#721),
inline views (i.e. what you try) is only possible in the FROM clause
of the MV definition, and not in the SELECT clause, as you are trying.

Daniel