If you are wanting to see the status (online or offline) of the tablespace, use the following query:

select tablespace_name, status from dba_tablespaces;


If the tablespace is offline is not available for data access.