>Does the NOLOGGING attribute stay with the index after it has been created? It doesn't, >correct? Welllll... Obviously, getting the error shows that it does. And perhaps reading something into the 26040 error, it must be tracked by block, maybe something in the Integrity Section at the beginning of the block... 10g might be more informative http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10755/dynv iews_1055.htm#REFRN30048 I'm also wondering if analyze...validate might tell us anything. Then again, if this is expected behavior, would it be a misfeature if analyze didn't pick it up? Joel Garry http://www.garry.to -- //www.freelists.org/webpage/oracle-l