ORA-01552: cannot use system rollback segment for non-system tablespace 'USERS'

ames@JILL>create table test(x int);
create table test(x int)
*
ERROR at line 1:
ORA-01552: cannot use system rollback segment for non-system tablespace 'USERS'

james@JILL>show parameters rollback

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
fast_start_parallel_rollback         string      LOW
rollback_segments                    string
transactions_per_rollback_segment    integer     5

sys@JILL>show parameters undo

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
undo_management              string      MANUAL
undo_retention                     integer     900
undo_tablespace                 string      UNDOTBS

想起来 上次使用pfile重建spfile时候可能没有指定undo_management 的参数。
于是：

sys@JILL>alter system set undo_management=auto scope=spfile;

System altered.

sys@JILL>startup force;
ORACLE instance started.

Total System Global Area 524288000 bytes
Fixed Size                  1284272 bytes
Variable Size             146802512 bytes
Database Buffers          373293056 bytes
Redo Buffers                2908160 bytes
Database mounted.
Database opened.
sys@JILL>show parameters undo

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
undo_management                      string       AUTO
undo_retention                       integer     900
undo_tablespace                      string      UNDOTBS


sys@JILL>conn james/james

Connected.

Practice make Perfect.   Keep Moming,James!

james@JILL>create table test(x int);

Table created.