2 Replies Latest reply: Jun 15, 2011 9:57 AM by Ben Speckhard-Oracle RSS

    EnableVersioning undo_space parameter

    Rumpi
      I see that the DBMS_WM.EnableVersioning procedure includes the undo_space parameter. I'm confused because I thought undo is a transaction thing and not a table thing. For instance what happens if you have two tables with versioning enabled to different undo_space settings in the same transaction? I suppose I'm interested in knowing if this undo parameter is the same or related to the more familiar transaction undo/rollback.

      Please explain what is meant by the undo_space parameter and how it relates to the more commonly understood sql rollback/undo.