Oracle中檢視哪些objects 是nologging 的

select  *  from all_tables where    logging='NO'    AND    owner<>'SYS'; 

select  *  from all_indexes where   logging='NO' AND    owner<>'SYS';

 

select * from  ALL_TAB_COLUMNS  where column_name LIKE  '%LOGGING%' ;  

 

SYS,ALL_ALL_TABLES,LOGGING,VARCHAR2,,,3,,,Y,17,,,,,,,,,,,CHAR_CS,3,NO,NO,,3,B,NO,YES
SYS,ALL_INDEXES,LOGGING,VARCHAR2,,,3,,,Y,23,,,,,,,,,,,CHAR_CS,3,NO,NO,,3,B,NO,YES
SYS,ALL_IND_PARTITIONS,LOGGING,VARCHAR2,,,7,,,Y,21,,,,,,,,,,,CHAR_CS,7,NO,NO,,7,B,NO,YES
SYS,ALL_IND_SUBPARTITIONS,LOGGING,VARCHAR2,,,3,,,Y,20,,,,,,,,,,,CHAR_CS,3,NO,NO,,3,B,NO,YES
SYS,ALL_LOBS,LOGGING,VARCHAR2,,,7,,,Y,11,,,,,,,,,,,CHAR_CS,7,NO,NO,,7,B,NO,YES
SYS,ALL_LOB_PARTITIONS,LOGGING,VARCHAR2,,,7,,,Y,22,,,,,,,,,,,CHAR_CS,7,NO,NO,,7,B,NO,YES
SYS,ALL_LOB_SUBPARTITIONS,LOGGING,VARCHAR2,,,3,,,Y,22,,,,,,,,,,,CHAR_CS,3,NO,NO,,3,B,NO,YES
SYS,ALL_OBJECT_TABLES,LOGGING,VARCHAR2,,,3,,,Y,17,,,,,,,,,,,CHAR_CS,3,NO,NO,,3,B,NO,YES
SYS,ALL_TABLES,LOGGING,VARCHAR2,,,3,,,Y,17,,,,,,,,,,,CHAR_CS,3,NO,NO,,3,B,NO,YES
SYS,ALL_TAB_PARTITIONS,LOGGING,VARCHAR2,,,7,,,Y,21,,,,,,,,,,,CHAR_CS,7,NO,NO,,7,B,NO,YES
SYS,ALL_TAB_SUBPARTITIONS,LOGGING,VARCHAR2,,,3,,,Y,20,,,,,,,,,,,CHAR_CS,3,NO,NO,,3,B,NO,YES
SYS,DBA_ALL_TABLES,LOGGING,VARCHAR2,,,3,,,Y,17,,,,,,,,,,,CHAR_CS,3,NO,NO,,3,B,NO,YES
SYS,DBA_INDEXES,LOGGING,VARCHAR2,,,3,,,Y,23,,,,,,,,,,,CHAR_CS,3,NO,NO,,3,B,NO,YES
SYS,DBA_IND_PARTITIONS,LOGGING,VARCHAR2,,,7,,,Y,21,,,,,,,,,,,CHAR_CS,7,NO,NO,,7,B,NO,YES
SYS,DBA_IND_SUBPARTITIONS,LOGGING,VARCHAR2,,,3,,,Y,20,,,,,,,,,,,CHAR_CS,3,NO,NO,,3,B,NO,YES
SYS,DBA_LOBS,LOGGING,VARCHAR2,,,7,,,Y,11,,,,,,,,,,,CHAR_CS,7,NO,NO,,7,B,NO,YES
SYS,DBA_LOB_PARTITIONS,LOGGING,VARCHAR2,,,7,,,Y,22,,,,,,,,,,,CHAR_CS,7,NO,NO,,7,B,NO,YES
SYS,DBA_LOB_SUBPARTITIONS,LOGGING,VARCHAR2,,,3,,,Y,22,,,,,,,,,,,CHAR_CS,3,NO,NO,,3,B,NO,YES
SYS,DBA_OBJECT_TABLES,LOGGING,VARCHAR2,,,3,,,Y,17,,,,,,,,,,,CHAR_CS,3,NO,NO,,3,B,NO,YES
SYS,DBA_TABLES,LOGGING,VARCHAR2,,,3,,,Y,17,,,,,,,,,,,CHAR_CS,3,NO,NO,,3,B,NO,YES
SYS,DBA_TABLESPACES,LOGGING,VARCHAR2,,,9,,,Y,11,,,,,,,,,,,CHAR_CS,9,NO,NO,,9,B,NO,YES
SYS,DBA_TAB_PARTITIONS,LOGGING,VARCHAR2,,,7,,,Y,21,,,,,,,,,,,CHAR_CS,7,NO,NO,,7,B,NO,YES
SYS,DBA_TAB_SUBPARTITIONS,LOGGING,VARCHAR2,,,3,,,Y,20,,,,,,,,,,,CHAR_CS,3,NO,NO,,3,B,NO,YES
SYS,USER_ALL_TABLES,LOGGING,VARCHAR2,,,3,,,Y,16,,,,,,,,,,,CHAR_CS,3,NO,NO,,3,B,NO,YES
SYS,USER_INDEXES,LOGGING,VARCHAR2,,,3,,,Y,22,,,,,,,,,,,CHAR_CS,3,NO,NO,,3,B,NO,YES
SYS,USER_IND_PARTITIONS,LOGGING,VARCHAR2,,,7,,,Y,20,,,,,,,,,,,CHAR_CS,7,NO,NO,,7,B,NO,YES
SYS,USER_IND_SUBPARTITIONS,LOGGING,VARCHAR2,,,3,,,Y,19,,,,,,,,,,,CHAR_CS,3,NO,NO,,3,B,NO,YES
SYS,USER_LOBS,LOGGING,VARCHAR2,,,7,,,Y,10,,,,,,,,,,,CHAR_CS,7,NO,NO,,7,B,NO,YES
SYS,USER_LOB_PARTITIONS,LOGGING,VARCHAR2,,,7,,,Y,21,,,,,,,,,,,CHAR_CS,7,NO,NO,,7,B,NO,YES
SYS,USER_LOB_SUBPARTITIONS,LOGGING,VARCHAR2,,,3,,,Y,21,,,,,,,,,,,CHAR_CS,3,NO,NO,,3,B,NO,YES
SYS,USER_OBJECT_TABLES,LOGGING,VARCHAR2,,,3,,,Y,16,,,,,,,,,,,CHAR_CS,3,NO,NO,,3,B,NO,YES
SYS,USER_TABLES,LOGGING,VARCHAR2,,,3,,,Y,16,,,,,,,,,,,CHAR_CS,3,NO,NO,,3,B,NO,YES
SYS,USER_TABLESPACES,LOGGING,VARCHAR2,,,9,,,Y,11,,,,,,,,,,,CHAR_CS,9,NO,NO,,9,B,NO,YES
SYS,USER_TAB_PARTITIONS,LOGGING,VARCHAR2,,,7,,,Y,20,,,,,,,,,,,CHAR_CS,7,NO,NO,,7,B,NO,YES
SYS,USER_TAB_SUBPARTITIONS,LOGGING,VARCHAR2,,,3,,,Y,19,,,,,,,,,,,CHAR_CS,3,NO,NO,,3,B,NO,YES