Re: Tracking down NOLOGGING objects
Date: Fri, 5 Sep 2008 21:02:19 -0500
I could test this, but it's late on a Friday night (why am I even reading this now?) but wouldn't the below example actually change the LOGGING status of the index so it is now LOGGING=NO? I believe it would. The same goes for the CTAS NOLOGGING example from Mark. That means my original query looking for objects with LOGGING=NO would have found them in the first place (unless of course you turn logging on after the object is created/rebuilt).
On Fri, Sep 5, 2008 at 8:07 PM, Mark Brinsmead <pythianbrinsmead_at_gmail.com>wrote:
> The ALTER INDEX ... REBUILD NOLOGGING example is -- of course -- a much
> better illustration of what I was thinking of. Not least of all because it
> happens to be correct. :-)