Re: materialized view rewrite

Maxim Demenko schrieb:
> Volker, either i don't understand you or you me.
> Try to change your ddl for materialized view omitting the "next sysdate
> + 1/144" ( like it is done in my example) part and see if you can create
> a view enabled for query rewrite.

You're right, that did it!

> This is of course a workaround if you are looking for
> working solution.

Workaround is fine by me.

Thanks a lot for your help!!
Volker

-- 
For email replies, please substitute the obvious.