Hi,

 

Apart from explicitly putting datafile or tabespace in offline mode though alter database….. or alter tablespace….. command , under what circumstances would STATUS column in v$datafile and dba_tablespaces change to OFFLINE?

 

Thanks.