The rule hint still exist in the all_tab_columns view which is causing us some significant performance problems and is a known issue on MOS. The "official" fix is to recreate the view without the hint, go figure. Ken Naim -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Rich Jesse Sent: Tuesday, March 16, 2010 2:13 PM To: oracle-l@xxxxxxxxxxxxx Subject: RE: Risk of RULE mode in 10g+ > EYY, just my luck. I've got a note here from an Oracle 10g new features > class that says it died. But then again how long ago did LONGS die??? > > Dick Goulet LOL -- anyone attempting a materialized view over 64KB knows they're still around and in use in the dictionary. :) Rich -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l