SELECT 'Tablespace '||t.tablespace_name ||' holding audit data in '||t.table_name||' is not encrypted.' value FROM dba_tables t, dba_tablespaces ts WHERE (t.table_name ='AUD$' OR t.table_name='FGA_LOG$' OR t.owner= 'AUDSYS') AND t.tablespace_name = ts.tablespace_name AND ...