ORA-30014: operation only supported in Automatic Undo Management mode

OS:REDHAT AS 4.6

DB:ORACLE 10.2.0.1

 

SQL> start cr_db.sql
CREATE DATABASE mydb
*
ERROR at line 1:
ORA-30014: operation only supported in Automatic Undo Management mode

SQL> !
[oracle@localhost scripts]$ oerr ora 30014
30014, 00000, "operation only supported in Automatic Undo Management mode"
// *Cause:   the operation is only supported in automatic undo mode.
// *Action:  restart instance in Automatic Undo Management mode before
//           retrying operation.

 

alter initialization parameter undo_management=AUTO

restart db;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/18914315/viewspace-740814/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/18914315/viewspace-740814/