数据文件offline & online
alter database datafile 5 offline;
alter database datafile 5 online;
system表空间的数据文件不能offline
select count(*),status,online_status from dba_data_files group by status,online_status;
COUNT(*) STATUS ONLINE_STATUS
---------- ------------------ --------------
5 AVAILABLE ONLINE
1 AVAILABLE SYSTEM