VIEW: SYS.LOGMNR$SCHEMA_ALLKEY_SUPLOG

Source

View Text - Preformatted

select name schema_name,
       (case when bitand(spare1, 64) = 64
            then 'YES' else 'NO' end) ALLKEY_SUPLOG,
       (case when bitand(spare1, 1024) = 1024
            then 'YES' else 'NO' end) ALLOW_NOVALIDATE_PK
from user$
where name in (select username from all_users)

View Text - HTML Formatted

SELECT NAME SCHEMA_NAME
, (CASE WHEN BITAND(SPARE1
, 64) = 64 THEN 'YES' ELSE 'NO' END) ALLKEY_SUPLOG
, (CASE WHEN BITAND(SPARE1
, 1024) = 1024 THEN 'YES' ELSE 'NO' END) ALLOW_NOVALIDATE_PK FROM USER$ WHERE NAME IN (SELECT USERNAME
FROM ALL_USERS)