|Materialized Views in Oracle - Use materialized views (snapshots) to replicate data to a remote database.|
Shahid said...create materialized view test3 build deferred refresh force
on demand enable query rewrite on prebuilt table as
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..
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