Sometimes you have lots of data but not enough space at your storage. And you need to check your tables sizes and tables spaces etc. I think it is easier use queries than use clients utilities.
We can use system tables for control size, parallelism degree , compression level and more. I use this two scripts for check things up.
First one the size ;
select
us.segment_name,
us.TABLESPACE_NAME,
sum(us.bytes)/1024/1024/1024 GB ,
sum(us.bytes)/1024/1024 MB
from user_segments us
where us.segment_type='TABLE'
and us.segment_name LIKE '%YOUR_TABLE_NAME%'
group by
us.segment_name ,
us.TABLESPACE_NAME;
The second one compress ,parallelism degrees and etc. ;
SELECT
ut.table_name ,
ut.tablespace_name ,
ut.logging,
ut.num_rows,
ut.degree ,
ut.instances ,
ut.last_analyzed ,
ut.partitioned
FROM user_tables ut
But generally I use them both as below ;
SELECT
us.table_name ,
us.TABLESPACE_NAME,
us.gb_SIZE,
us.mb_SIZE,
ut.logging,
ut.num_rows,
ut.degree ,
ut.instances ,
ut.last_analyzed ,
ut.partitioned ,
ut.compression
FROM
( select
us.segment_name table_name ,
us.TABLESPACE_NAME,
sum(us.bytes)/1024/1024/1024 GB_SIZE ,
sum(us.bytes)/1024/1024 MB_SIZE
from user_segments us
where us.segment_type='TABLE'
and us.segment_name LIKE '%Z$%'
AND TABLESPACE_NAME ='SATA'
group by
us.segment_name ,
us.TABLESPACE_NAME ) us
INNER JOIN
(SELECT
ut.table_name ,
ut.tablespace_name ,
ut.logging,
ut.num_rows,
ut.degree ,
ut.instances ,
ut.last_analyzed ,
ut.partitioned ,
ut.compression
FROM user_tables ut ) ut
ON us.table_name = ut.table_name
AND us.TABLESPACE_NAME = ut.TABLESPACE_NAME
ORDER BY MB_SIZE DESC
I will be glad if it helps ,
Have a nice day