Ray Stell wrote: > I have seen statements like the following on metalink wrt mview > master table reorgs: > > "With a read-only MV/snapshot you will have to recreate the > MV to get the new column added." > [...] > > They never seem to refer to underlying docs, however. Where is this > discussed in the docs? Thanks. > http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10736/advmv.htm#sthref589 "All other changes are achieved by dropping and then re-creating the materialized view." -- Mark Bole http://www.bincomputing.com -- //www.freelists.org/webpage/oracle-l