如果数据库启用了强制日志记录，则会覆盖对表指定的nologing;
如果在表空间指定了日志记录子句，也会为任何没有显式使用日志记录子句的create table语句设置默认的日志记录值：
1.v$database:
SQL> select name,log_mode,force_logging from v$database;
NAME LOG_MODE FOR
------------------------------ ------------ ---
ORCL NOARCHIVELOG NO
2.dba_tablespaces:
SQL> select tablespace_name,logging from dba_tablespaces;
TABLESPACE_NAME LOGGING
------------------------------ ---------
SYSTEM LOGGING
SYSAUX LOGGING
UNDOTBS1 LOGGING
TEMP NOLOGGING
USERS LOGGING
EXAMPLE LOGGING
3.dba_tables:
SQL> select table_name,tablespace_name,logging from dba_tables where table_name='F_REGS';
TABLE_NAME TABLESPACE_NAME LOG
------------------------------ ------------------------------ ---
F_REGS USERS NO

ITPub博客

查看logging的模式