select tablespace_name,logging,status from dba_tablespaces; select tablespace_name,contents from dba_tablespaces;