To get the space taken up by all the objects in the schema, the following query can be used

select ((sum(bytes)/1024)/1024)/1024 Space_in_GB from dba_segments where owner=’SCHEMA_NAME’