Can i create Materialized view on a Materlized view.

[Pratibha Malhotra]

Database B has Materlized views on base tables existing in Database A.
Now, Can i create materilized views on materilized views located in Database B.

ie

Database A --> Database B --> Database C
Table A MV on Table A MV on MV in Database B

If yes, what all do i need to do?

[Mark Spritzler]

Yes you can, because a Materialized view actually has data stored.

However, there is a caveat. If the underneath Materialized view is out of date, and you try to refresh the upper Materialized view, the data will not be correct, and sometimes you get an error, if I remember correctly.

Mark