Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: materialized view rewrite
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