Find the Size of Schema in Database

Below query will help you out in finding the size of the schema in database

Select sum(bytes)/1024/1024/1024 GB, tablespace_name from dba_segments where owner='XXXXX' group by tablespace_name

NEED TO REPLACE XXXXX WITH THE SCHEMA NAME THAT NEEDS TO BE EXPORTED