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

DO NOT ask technical questions here, that's what my forum is for!

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!

Add your comments here.
Name
Comment
(max 400 chars - plain text)