Re: how do I calculate free space in schema

Thanks.....well I have cribbed this query to tell me space used by schema
SELECT owner,

   Sum(bytes)/1024/1024 AS total_size_mb   FROM dba_segments
  WHERE owner = Upper('Owner_name')
  GROUP BY owner;

many thanks...... Received on Fri Nov 04 2005 - 03:17:09 CST