OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Rollback seg

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

Rollback seg [message #64286]

Mon, 10 January 2005 00:40

Abdulla
Messages: 1
Registered: January 2005

Junior Member

Why is it not possible to create a rollback segment initially in a Locally Managed Table space ?

Report message to a moderator

Re: Rollback seg [message #64290 is a reply to message #64286]

Mon, 10 January 2005 03:53

Frank Naude
Messages: 4596
Registered: April 1998

Senior Member

Hi,

What version of Oracle are you using? Is your database maybe using AUM (undo_management = TRUE)? If so, Oracle will create its own rollback segments (called undo segments) and you don't have to bother creating them. If not, post the command issued with the complete error (hell, why do we need to ask for this every time!).

Best regards.

Frank

Report message to a moderator

Re: Rollback seg [message #64335 is a reply to message #64286]

Wed, 12 January 2005 23:19

naveed
Messages: 5
Registered: October 2001

Junior Member

see upto to 9.0.1 manual rollback segments cannot
be created in locally managed tbs this shorting comming
has been eliminated from oracle 9.2.0 version
now in 9.2.0 first create a rollback segment in
tablespace system and make it online and then create rollback segments in any locally managed tbs

Report message to a moderator

Previous Topic:	unlock the records
Next Topic:	Very Urgent and Imp

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 02 14:45:15 CDT 2025