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