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