Find users belongs to tablespace

select distinct owner from dba_segments where tablespace_name='DATA201502';



OWNER
------------------------------
CC_OWNER
CM_POS2
PAYMENT
VT_IT_TC_KM
PRIVILEGE_OWNER
MEDIATION
BCCS_GW
QLKD_BD

8 rows selected.

Tweet