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?
Asked
Active
Viewed 1.9k times
1 Answers
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
-
You are welcome.Please do mark the answer as useful.Thanks. – Kaushik Nayak Jul 23 '17 at 16:45
-
Thanks Abhijit. Could u also mark it as the best answer since there are no other answers so far?..:) – Kaushik Nayak Jul 24 '17 at 05:15
-
How? I am new in here. – Somadder Abhijit Jul 30 '17 at 11:46
-
Click the green outlined checkmark to the left of the answer that solved your problem.This marks the answer as "accepted", and by extension the question as "has an accepted answer". – Kaushik Nayak Jul 30 '17 at 15:48