Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: materialized view rewrite

Re: materialized view rewrite

From: Volker Hetzer <firstname.lastname_at_ieee.org>
Date: Mon, 28 Aug 2006 17:44:40 +0200
Message-ID: <ecv319$nms$1@nntp.fujitsu-siemens.com>


Maxim Demenko schrieb:
> If you omit "next sysdate + 1/144" part of refresh clause, view will be
> created. You can then manually setup job to refresh it automatically.
Unfortunately, the problem is not the refresh, the problem is that oracle will not create the view if I set the "enable query rewrite" clause. It complains about dxdb_cmsattrib but I don't see anything to complain about.

Lots of Greetings!
Volker

-- 
For email replies, please substitute the obvious.
Received on Mon Aug 28 2006 - 10:44:40 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US