We have a BUILD_MODE (IMMEDIATE / DEFERRED / PREBUILT) clause which can be used as follows with the materialized view, 'create materialized view skills ON PREBUILT TABLE WITH REDUCED PRECISION as select NUM from skills_data'. Also WITH / WITHOUT REDUCED PRECISION can be used with this PREBUILT clause above. I need to find the table wherefrom I can know if the materialized view has been created with reduced precision or otherwise

-- Abhijeet Gadgil (Abhijeet_Gadgil@bmc.com), December 03, 2003