▷ Oracle datafile status (오라클 데이터파일 상태)

[ Oracle datafile status ]

--col FILE_NAME for a40

select a.file_id,
a.FILE_NAME,
a.TABLESPACE_NAME,
b.status,
fuzzy as Backuped,
a.bytes/1024/1024
from dba_data_files a,
v$datafile_header b
where a.file_name = b.name
order by 1;