怎么还可以将表：

ALTER TABLE  DEPT    LOGGING

很正常啊

SQL> alter tablespace users nologging;

Tablespace altered.

SQL> select default_tablespace from dba_users where username='BOSON';

DEFAULT_TABLESPACE
------------------------------
USERS

SQL> show users;
SP2-0158: unknown SHOW option "users"
SQL> show user;
USER is "BOSON"
SQL> create table test_logging (id number) logging;

Table created.

SQL> alter table test_logging nologging;

Table altered.

SQL> alter table test_logging logging;

Table altered.

QUOTE:

---

原帖由 suniori 于 2008-7-4 14:58 发表
很正常啊

---

就是说logging 还是nologging，
主要还是看表，不是看表空间 ？