Oracle query get schema name, size and creation date
select u.username, 
       u.created, 
       round(nvl(sum(s.bytes)/1024/1024,0),2) size_mb
  from dba_users u
  left outer join dba_segments s on (s.owner = u.username)
 group by u.username, u.created
 order by u.username;