Forums | Aggregator | Books | Industry News | Firefox Plugins | Social | Links

Comments

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
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...

Hi.

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.

Cheers

Tim...

Prathap said...

Very useful
Prepared Statement Error: Table './oraclebasecms/cms_page_comment_uuids' is marked as crashed and should be repaired