Home » RDBMS Server » Server Administration » What is an Undo Tablespace?
What is an Undo Tablespace? [message #136320] Wed, 07 September 2005 08:58 Go to next message
wtolentino
Messages: 422
Registered: March 2005
Senior Member
I had read about the undo tablespace on oracle database concepts manual. What is the purpose of undo tablespace and how can it be utilized when issuing a dml operation? An example would help. Thanks.

Report message to a moderator

Re: What is an Undo Tablespace? [message #136326 is a reply to message #136320] Wed, 07 September 2005 09:18 Go to previous message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
THe same functionality of ROLLBACK segments.
Just improved.
FUnctionsare to provide read consistency, to rollback the data if the transaction fails etc.
http://asktom.oracle.com/pls/ask/f?p=4950:8:704229416027102788::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:275215756923
http://asktom.oracle.com/pls/ask/f?p=4950:8:704229416027102788::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:7705505116425

Report message to a moderator

Previous Topic: Create table problem using Dynamic Query
Next Topic: ORA-27101: Shared memory realm does not exist
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Feb 13 14:27:30 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.