2

I have created a new tablespace and also some users. I have assigned those users to the tablespace. What is the query for finding out the users for the tablespace?

Somadder Abhijit
  • 85
  • 1
  • 3
  • 9

1 Answers1

4
 SELECT TABLESPACE_NAME,USERNAME 
 FROM  DBA_TS_QUOTAS 
 WHERE TABLESPACE_NAME = '<your_tablespace>';

If Tablespace quotas are not available, then:

select USERNAME, DEFAULT_TABLESPACE, TEMPORARY_TABLESPACE
from DBA_USERS
where DEFAULT_TABLESPACE='<your_tablespace>';
Kaushik Nayak
  • 30,772
  • 5
  • 32
  • 45