We got ora-4045 while running a query again a materialized view. It seems the Materialized View needs to be compiled.
According to Oracle: 'A materialized view is automatically revalidated when it is referenced'. We only had DML on the base tables.
So when the materialized views will be 'automatically revalidated' and when they will not and we get ora-4045?