Archive

Archive for March, 2011

How to check for LOGGING/NOLOGGING objects in the DB?

March 14, 2011 Leave a comment

Two example methods of querying the database for this information:

select owner , table_name, index_name
from dba_indexes
where logging='NO';

select tablespace_name, logging
from dba_tablespaces
/

Source: LOGGING OR NOLOGGING THAT IS THE QUESTION By Francisco Munoz Alvarez