Re: ORA-30045: No undo tablespace name specified

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. Since you are creating an database, you do not yet have an UNDO tablespace. But that is what the UNDO TABLESPACE clause of the CREATE DATABASE statement is for. It creates the database and the UNDO tablespace at the same time. By setting UNDO_MANAGEMENT to MANUAL, you did not need the UNDO tablespace, therefore you did not receive the ORA-30045 error. Now that your database is created, you can manually create the UNDO tablespace with the CREATE UNDO TABLESPACE command and then set your UNDO parameters accordingly.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"