select tablespace_name, status from dba_tablespaces

TABLESPACE_NAME	STATUS
SYSTEM	ONLINE
UNDOTBS	ONLINE
TEMP	ONLINE
BLOBS	ONLINE
INDX	ONLINE
TOOLS	ONLINE
USERS	ONLINE