SELECT DISTINCT OWNER FROM DBA_SEGMENTS WHERE TABLESPACE_NAME='EXAMPLE';
OWNER
------------------------------------------------------------
HR
OE
PM
SH
IX
DROP USER HR CASCADE;
DROP USER OE CASCADE;
DROP USER PM CASCADE;
DROP USER SH CASCADE;
DROP USER IX CASCADE;
DROP TABLESPACE EXAMPLE INCLUDING CONTENTS AND DATAFILES;