文档解释
ORA-30045: No undo tablespace name specified
Cause: If Create Database has the datafile clause, then undo tablespace name has to be specified, unless using OMF.
Action: Specify the undo tablespace name.
ORA-30045: No undo tablespace name specified 错误是Oracle数据库在创建架构时发出的一个错误。它表明创建用户时,未指定用户最初进入系统使用的Undo tablespace(回滚表空间)。
官方解释
‘When attempting to create a user, the creation process failed and the following error was encountered: ORA-30045: No undo tablespace name specified.
‘This error reflects that when creating a user, Undo tablespace (or rollback segment) is not specified that is to be used when the user enters the system for the first time. ’
常见案例
在创建用户时,在用户输入系统时,数据库引擎未指定用户应该使用的回滚表空间,就会发出ORA-30045错误。
一般处理方法及步骤
要修复这个错误,可以在创建用户时,在指定表空间和默认临时表空间之后,指定一个回滚表空间,并使用如下形式的SQL语句来完成:
CREATE USER username
IDENTIFIED BY password
DEFAULT TABLESPACE tablespace_name
TEMPORARY TABLESPACE tablespace_name
UNDO TABLESPACE tablespace_name;