On Commit Preserve Rows
On Commit Preserve Rows . They will only be removed at the end of the session. The disk space is reclaimed immediately. 关于on commit preserve rows与on commit delete rows的测试 itcui 博客园 from www.cnblogs.com Invoke another procedure (nested) and populate few more columns of the gtt. As per my knowledge on commit preserve rows preserves records until end of the session (my oracle knowledge is poor, my assumption could be wrong). After committing a transaction, the recordset remains active.