Sorry about the delay in replying.
Attached is a simple SQL example of materialized views
which may give you a clue to where things are going
wrong.
Since Oracle can rewrite even complex variations,
a little thing like changing the case is NOT going to
be the problem.
The script builds a demo t
I've gone thru the FM for about 4 hours now, to no avail.
I thought oracle uppercased tables and columns that were not enclosed in
double quotes("), but for query rewrite to pick up on a materialized view, the
SQL has to be EXACT(oracle supposedly strips whitespace), but if i spell the
tabl