Skip to Main Content

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 Determine if a tablespace contains objects

user59655Jul 24 2008 — edited Jul 25 2008
Hello -

What is the best query to determine if a tablespace contains objects?

I am using this query:
select distinct owner from dba_extents
where tablespace_name = 'MYTS';

I am not getting any rows returned, so is it safe to drop this tablespace? I only want to drop if it contains no data or objects.

Thanks in advance!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 22 2008
Added on Jul 24 2008
14 comments
1,927 views