Create Materialized View from a virtual View

0
votes

I'm new to oracle and materialized views. I have created a view for data that was producing a big bottleneck in our application. For reducing the complexity of the virtual view, the data were divided in respective part virtual views reflecting some business domain. I.e. the main virtual view which I want to use for the materialized view contains data joined from the part virtual views.

My question is, if I can create a materialized view from the main virtual view. Forther, II would like the data updated by each commit.

create materialized view log on main_view;
create materialized view main_view_mv refresh fast on commit
as select col_1 from main_view;
commit;

Is it possible to create the materialized view? Are these commands OK to refresh the materialized view?

Thnaks for the any hint.

1
oracleviewrefreshmaterialized-views
There's no "virtual" views, they're just views. - Jeffrey Kemp

1 Answers

1
votes

To answer your question: no, you can't create materialized view logs on a view - only on tables. The requirements for a FAST refreshable materialized view are described in this answer

Materialized views aren't a magic tool to make slow views execute fast. You'll probably have to examine why the main view is slow.