Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to know what user/schema uses a Tablespace

DelmonteMay 21 2012 — edited May 21 2012

Hello,

I have a Tablespace named MSE. I don't know what schema or user uses it. Is there any query to show that?

I run this query to know what tables belong to tablespace MSE, but it returns 0 rows.

select t.table_name,t.tablespace_name,df.file_name from dba_tables t, dba_data_files df
where t.tablespace_name = df.tablespace_name
AND t.tablespace_name = 'MSE'

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 18 2012

Added on May 21 2012

#general-database-discussions

3 comments

1,835 views