OraFAQ Forum: Enterprise Manager » Diff. between undo & rollback segments??

Home » RDBMS Server » Enterprise Manager » Diff. between undo & rollback segments??

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

Diff. between undo & rollback segments?? [message #68386]

Fri, 11 July 2003 02:39

sachin kumar gupta
Messages: 157
Registered: March 2003

Senior Member

Hi all,
Can anyone help me !! My question is what is the difference between undo & rollback segment.

TIA,
Sachin

Report message to a moderator

Re: Diff. between undo & rollback segments?? [message #68400 is a reply to message #68386]

Mon, 21 July 2003 06:23

rambabu
Messages: 3
Registered: July 2003

Junior Member

hai
Both will do the same functionality,but in oracle 9i they made it simplify ,because if u are using rollback segments ,u need to put them online in init.ora and u need to take care space management etc.
so in oracle 9i they introduced undo tablespaces on that u can creage undo segments and space management will be take care by oracle managed files ,so its reduces the burden of dba

Report message to a moderator

Previous Topic:	Help! Services.ora picks up only webserver and no databases
Next Topic:	ORA-12638

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 03 14:00:15 CST 2025