I've found that I can have two tables and create a `fast refresh on commit` `materialized view` based on those tables joined.

What I would like to do however is to make a `fast refresh on commit` materialized view based on the following:

(1) A table JOINED TO  

(2) A `complete refresh on demand` materialized view which itself is based on other views (ordinary views, that is).

When I try to this I get error `ORA-12053`, which talked about entries in the `from` clause having dependencies on each other, even when they clearly don't.

I can work around this by replacing (2) with an ordinary table, and just doing a bulk insert into this table instead of refreshing the materialized view. However, I'd rather not do this if not necessary.

I'll try to work on a minimal example that illustrates the error, but if you could give me an idea of whether what I want to do is possible (preferably by an example) or not possible that would be great.