select distinct owner from dba_objects, dba_users where owner not in ('SYS','SYSTEM','MDSYS','CTXSYS', 'ORDSYS','ORDPLUGINS','AURORA$JIS$UTILITY$', 'ODM','ODM_MTR','OLAPDBA','OLAPSYS','MTSSYS', 'OSE$HTTP$ADMIN','OUTLN','LBACSYS', 'PUBLIC','DBSNMP','RMAN','WKSYS', 'WMSYS','XDB') and owner = username and account_status not like '%LOCKED'; |
DBA FUS >