Re: ORA-30045: No undo tablespace name specified

On Wed, 7 Apr 2004 20:47:50 GMT, Brian Peasland <dba_at_remove_spam.peasland.com> wrote:

> Andrew wrote:
>>
>> I ran into this bad boy while trying to create a database on oracle
>> 9i. For me the solution was to change the following in the init.ora
>> file.
>>
>> from:
>> undo_management = AUTO
>>
>> to:
>> undo_management = MANUAL
>>
>> Hope this helps...
>
>
> If you have UNDO_MANAGEMENT=AUTO, then you must also have set
> UNDO_TABLESPACE to a valid UNDO tablespace name.

Actually, that's not quite true. If you set UNDO_MANAGEMENT=AUTO and leave UNDO_TABLESPACE totally unset, then Oracle will acquire the first undo tablespace it can find at startup time, automatically. The trouble starts when you explicitly set UNDO_TABLESPACE to something that is invalid. But yes, in the context of actually trying to create a database, the distinction between having to set a valid UNDO_TABLESPACE and having NOT to set an INvalid one, is moot.

Regards
HJR

-- 
-------------------------------------------
Dizwell Informatics: http://www.dizwell.com
  -A mine of useful Oracle information-
          -Windows Laptop Rac-
    -Oracle Installations on Linux-
===========================================