DBA Hub

📋Steps in this guide1/1

How to Find Empty Tablespace ?

Here is the query that we identify empty tablespaces.

oracle configurationintermediate
by OracleDba
13 views
1

Overview

Code/Command (click line numbers to comment):

1
2
3
select name tablespace_name from v$tablespace where ts# > 6 and name not in (select distinct tablespace_name from dba_segments) and name not in (select tablespace_name from dba_tablespaces where contents = 'TEMPORARY') order by 1;

SQL> select name tablespace_name from v$tablespace where ts# > 6 and name not in (select distinct tablespace_name from dba_segments) and name not in (select tablespace_name from dba_tablespaces where contents = 'TEMPORARY') order by 1;

Comments (0)

Please to add comments

No comments yet. Be the first to comment!