Friday, November 27, 2015

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.

Share this

0 Comment to "Find users belongs to tablespace"

Post a Comment