select username from dba_users where username not in(
SELECT NAME FROM (SELECT CID, CNAME, SCHEMA# FROM SYS.REGISTRY$ UNION ALL SELECT A.CID, CNAME, B.SCHEMA#
FROM SYS.REGISTRY$ A, SYS.REGISTRY$SCHEMAS B WHERE A.CID = B.CID) A,SYS.USER$ B WHERE A.SCHEMA# = B.USER# )
order by username
SELECT NAME FROM (SELECT CID, CNAME, SCHEMA# FROM SYS.REGISTRY$ UNION ALL SELECT A.CID, CNAME, B.SCHEMA#
FROM SYS.REGISTRY$ A, SYS.REGISTRY$SCHEMAS B WHERE A.CID = B.CID) A,SYS.USER$ B WHERE A.SCHEMA# = B.USER# )
order by username