8i | 9i | 10g | 11g | 12c | 13c | Misc | PL/SQL | SQL | RAC | Linux

Home » Misc » Here

Comments for Materialized Views in Oracle

Shahid said...

create materialized view test3 build deferred refresh force
on demand enable query rewrite on prebuilt table as
select *
from test2;

Error: Missing keyword

As per the given syntax by you i have written this query.But i am getting error.please help how to proceed further..

Tim... said...


This is not from my article. This is something you have written. Please post your question in the forum, giving the create table statement this is based on, then I will take a look.



Prathap said...

Very useful

DO NOT ask technical questions here! They will be deleted!

These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!