alter rollback segment SEGMENT_NAME online : Transaction Rollback Commit « Table « Oracle PL / SQL






alter rollback segment SEGMENT_NAME online

    

SQL> alter rollback segment SEGMENT_NAME online;
SQL>
SQL>
SQL> commit;
SQL>
SQL>

   
    
    
    
  








Related examples in the same category

1.Transaction Rollback and commit
2.atomicity: roll back and commit
3.Rollback a delete
4.TRANSACTION CONTROL
5.set transaction use rollback segment SEGMENT_NAME
6.show autocommit
7.Transactions and Error Handling
8.Transactions and Savepoints
9.SET TRANSACTION READ WRITE
10.Rollback to savepoint in exception handler