Re: how do I calculate free space in schema

It is included if you use dba_segments as can be seen in the following query ...
Select segment_type,sum(bytes) from dba_segments group by segment_type;

SGTYPE                 SUM(BYTES)
---------------------- ----------
CLUSTER                  33030144
INDEX                  1741070336
INDEX PARTITION          10551296
LOB PARTITION              196608
LOBINDEX                 75481088
LOBSEGMENT               86515712
NESTED TABLE               229376
ROLLBACK                   409600
TABLE                  1292369920
TABLE PARTITION          11747328
TYPE2 UNDO               81199104