Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to create a definitive list of objects with NOLOGGING

marksmithusaMay 19 2011 — edited May 20 2011

Hi, all,

How might I create a definitive list of objects which might be affected by NOLOGGING. I've checked dba_tables, dba_indexes, dba_lobs and dba_tablespaces. I presume these are the only objects which have a LOGGING/NOLOGGING setting. Are there any others I've missed? Does anyone have a cunning script?

Mark

This post has been answered by Iordan Iotzov on May 19 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 17 2011

Added on May 19 2011

#general-database-discussions

6 comments

1,467 views