|
-
If you were only to identify what object type
in a certain tablespace then:
select distinct segment_type
from dba_segments
where tablespace_name='TABLESPACE_NAME';
The consumed size of your tablespace becomes lower
because you issues commands to optimize your objects
resulting your tablespace to consume less size where in
your object resides.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|