Hello,
I'm getting this error
ORA-01719: outer join operator not allowed in operand of OR or IN
When running this sql
set linesize 200
set pagesize 2000
col TABLESPACE_NAME for a30
col encrypted for a10
col encryptionalg for a12
col host_name for a16
break on host_name
SELECT ts.tablespace_name, et.MASTERKEYID, ts.encrypted, et.encryptionalg, ts.STATUS, i.host_name, w.WRL_TYPE
FROM dba_tablespaces ts, v$encrypted_tablespaces et, v$tablespace t, v$instance i, v$encryption_wallet w
WHERE t.ts# = et.ts#
AND (ts.tablespace_name = t.name and ts.tablespace_name not in ('SYSTEM','SYSAUX','UNDOTBS1') and CONTENTS <> 'TEMPORARY' and ENCRYPTED = 'NO')
or (WRL_TYPE<>'HSM' and w.STATUS='OPEN' and i.INSTANCE_NAME not in ('breezy','wicked'))
order by 3
/
Can somebody help me so this error goes away ?