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#
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/3345/viewspace-1027670/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/3345/viewspace-1027670/