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
table Ft_SALES and the materialized view sql says FT_SALES, no rewrite is
done.
Is this the way its supposed to work, i'd thought oracle would have been
smart enough to do the upper on anythin not in " and then do the compare,
guess i'm asking for too much.
I'm done venting.
joe
Received on Thu Aug 30 2001 - 10:23:05 CDT
