解决方法:
SQL> create undo tablespace tbs_undo datafile 'd:\oracle\product\10.2.0\oradata\orcl\undotbs02.dbf' size 500M ;
Tablespace created.
SQL> alter system set undo_tablespace='tbs_undo' scope=both;
System altered.
SQL> show parameter undo
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
undo_management string AUTO
undo_retention integer 900
undo_tablespace string tbs_undo
参考资料:
http://blog.chinaunix.net/uid-292484-id-2134265.html
http://www.itpub.net/thread-1232789-1-1.html
转载于:https://www.cnblogs.com/wuhenke/archive/2012/05/03/2480940.html
相关资源:数据结构—成绩单生成器