Re: mview docs

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



--
http://www.freelists.org/webpage/oracle-l