Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-30045: No undo tablespace name specified
> 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