vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| Hello Oracle 9.2i. What is difference between rollback segment and undo segment ? I fought that is was the same, but in many palces in documentation i find 'rollback' and in others 'undo' segment. Is there any difference ? Thanx Michal |
| ||||
| Michael, Oracle 9 introduced the concept of system managed rollback using an undo tablespace. The undo tablespace contains undo segments. Prior to version 9 rollback tablespaces which contained manually managed rollback segments performed this function. You will need to look at the context of the material to tell if the documentation is using the term undo in a generic sense that covers both undo and rollback operations which are basically the same or is talking directly about system managed undo and how Oracle manages it. HTH -- Mark D Powell -- |