Database Administration05 marksUNDO tablespace and UNDO RETENTION policy
What is UNDO tablespace and UNDO RETENTION policy? How to view and alter UNDO RETENTION Policy in oracle.
What is UNDO tablespace and UNDO RETENTION policy? How to view and alter UNDO RETENTION Policy in oracle. [5]
An UNDO tablespace is a special type of tablespace in Oracle Database used to store undo data (also called rollback data). When a transaction modifies data, Oracle saves the before-image of the data in the undo tablespace so that: - Transaction Rollback - Uncommitted changes can be undone if a tr...