Re: Problems with materialized views in Oracle8i

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sun, 27 Jun 1999 21:51:54 +0100
Message-ID: <930517130.3231.0.nnrp-12.9e984b29@news.demon.co.uk>

Problem solved.
Oracle is being a little fussy about the definition of the materialized view - with a (trivial but counter-intuitive) change in the definition the multiple join-back worked perfectly.

Details and sample scripts will be posted to my website over the next couple of weeks.

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

Jonathan Lewis wrote in message
<930300114.18991.0.nnrp-08.9e984b29_at_news.demon.co.uk>...
>However, if the join back is to two tables, and
>the dimension is defined across these two tables
>(in fact my dimension is defined across 3 tables)
>then the rewrite does not occur - even when I
>include the hint.
Received on Sun Jun 27 1999 - 15:51:54 CDT