Check status of tablespace offline or online in Oracle
Check the tablespace status is offline or online.
SELECT TABLESPACE_NAME,STATUS FROM DBA_TABLESPACES;Take the tablespace offline.
alter tablespace ts_name offline;Take the tablespace online
alter tablespace ts_name online;