OraFAQ Forum: Server Administration » is it a database only with one undo

Home » RDBMS Server » Server Administration » is it a database only with one undo_tablespace ?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

is it a database only with one undo_tablespace ? [message #150657]

Thu, 08 December 2005 23:29

raddisonlee
Messages: 29
Registered: March 2005

Junior Member

hi , pls tell me a right concept that
if one d.b can with a undo_tablesoace only one , which run in undo 'smu' mode ???
if d.b system exist one more undo_tablespaceS , how to allocate it ?

ORACLE9IR2 ,WIN2K,single instance ........

Report message to a moderator

Re: is it a database only with one undo_tablespace ? [message #150664 is a reply to message #150657]

Fri, 09 December 2005 00:01

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

In small
"Every database needs its own undo tablespace".

Elaborate your problem so that it could be discussed properly.

regards,
tarun

Report message to a moderator

Re: is it a database only with one undo_tablespace ? [message #150693 is a reply to message #150664]

Fri, 09 December 2005 01:35

raddisonlee
Messages: 29
Registered: March 2005

Junior Member

thanks tarun..
just want to make it clear that if in a oracle database ,it 's own one undo_tablespace only ? and we can't create one more undo tablespaces for d.b , is it right ???
thanks a lots...

Report message to a moderator

Re: is it a database only with one undo_tablespace ? [message #150694 is a reply to message #150693]

Fri, 09 December 2005 01:38

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

You can create more than one undo tablespace for a database but at a time you can use only one.

Report message to a moderator

Previous Topic:	Companion CD
Next Topic:	Startup and shutdown databases

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Sep 09 22:31:04 CDT 2025