select distinct(b.file#), a.datafile_blocks*8192/1024/1024/1024 from RC_BACKUP_DATAFILE a,DF b
where a.db_name='DB_NAME'
and a.completion_time>=to_date('20090810','yyyymmdd')
and a.completion_timeand a.creation_change#=b.create_scn order by b.file#