This content has been marked as final. Show 2 replies
Srini Chavali wrote:You can submit your comments in the same page, under "Reader Comment" section -- Comments, corrections, and suggestions are forwarded to authors every week.
In the 11gR2 Upgrade Doc at http://docs.oracle.com/cd/E11882_01/server.112/e23633/upgrade.htm#i1011372, section titled "Verifying That Materialized View Refreshes Have Completed", the following statement is documented
It is missing the column names after the SELECT - can this be fixed please ?
SQL> SELECT FROM sys.obj$ o, sys.user$ u, sys.sum$ s WHERE o.type# = 42 AND bitand(s.mflags, 8) = 8;