Oracle 查询非库默认账户

select USERNAME, ACCOUNT_STATUS, DEFAULT_TABLESPACE,
       TEMPORARY_TABLESPACE, CREATED, PROFILE
  from dba_users
 where username not in 
       ('MDDATA', 'MDSYS', 'ORDSYS',
        'CTXSYS', 'ANONYMOUS', 'EXFSYS',
        'OUTLN', 'DIP', 'DMSYS', 'WMSYS',
        'XDB', 'ORACLE_OCM', 'TSMSYS',
        'ORDPLUGINS', 'SI_INFORMTN_SCHEMA',
        'OLAPSYS', 'SYSTEM', 'SYS', 'SYSMAN',
        'DBSNMP', 'PERFSTAT', 'PUBLIC','MGMT_VIEW',
        'WK_TEST', 'WKPROXY', 'WKSYS');
-- 并没有过滤掉SCOTT和HR用户