Pando,
The guy wants to know which tbs is read only. So he searches for the unknown thus
select tablespace_name from dba_tablespaces where status ='READ ONLY';


look at his original post.