Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-30045: No undo tablespace name specified

Re: ORA-30045: No undo tablespace name specified

From: Brian Peasland <dba_at_remove_spam.peasland.com>
Date: Wed, 7 Apr 2004 21:50:27 GMT
Message-ID: <407477A3.82D077E7@remove_spam.peasland.com>


> 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.

Thanks for refreshing my memory.

> 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.

Yes. If you do not have a valid UNDO tablespace, and you do not explicitly create one with the CREATE DATABASE command, then automated undo will generate this error.

Thanks,
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"
Received on Wed Apr 07 2004 - 16:50:27 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US