Materialized View in Oracle 9.2.0.5

[barnard90]

Hi

I am trying to create a Materialized View based on a Normal View for Complete Refresh in Oracle 9.2.0.6

The normal view is Employee_V

CREATE MATERIALIZED VIEW Employee_MV AS SELECT * FROM Employee_V

This works perfectly well in Oracle 9.2.0.6.

But the Materialized View Creation Fails in Oracle 9.2.0.5
with the same Create Options
Is there a limitation in Oracle 9.2.0.5 in Creation of a Materialized View based on a Normal View ?

Could some one please verify If a Materialized View could be created in Oracle 9.2.0.5 based on a Normal View
Please suggest

Thanks

 

[taupirho]

I just tried to create an MV based on a view on Oracle 9.2.0.2.0 and it worked perfectly


Try

CREATE MATERIALIZED VIEW Employee_MV
AS SELECT * FROM (select * from Employee_V)

See if that works

 

[barnard90]

The Error I am getting in 9.2.0.5 is

'Cannot Create Materialized View with a Sub Query'

I have a Sub query in my View Definition Employee_V.
That Sub query is necessary
Is there a way that I can have tge sub query in View Creation and I can still create a materialized view
based on the normal view in 9.2.0.5