Oracle Database Discussions

Hello,

My entire database and all tablespaces were running with NOLOGGING. I want to change this to have everything be LOGGING. I did a ALTER DATABASE FORCE_LOGGING command, but when I query I see this:

SELECT FORCE_LOGGING FROM V$DATABASE;

YES

SELECT FORCE_LOGGING, TABLESPACE_NAME FROM DBA_TABLESPACES;

all tablespaces return NO

Does the fact that FORCE_LOGGING is set from the database level trump the tablespace level? Or, do I need to enable force_logging at the tablespace level as well?

Mimi