![oracle 10g end of support oracle 10g end of support](https://demo.vdocuments.mx/img/378x509/reader023/reader/2020111903/55b54233bb61eb3a3a8b45bd/r-2.jpg)
Questionĭata locking makes the remainder of a table available to other users while you work on a particular row, and it also prevents multiple users from changing a row at the same time. Rather than rolling back to the previous commit state, you can instead roll back to a particular savepoint. Each savepoint has a name so that you can specify the one to which you wish to roll back.
![oracle 10g end of support oracle 10g end of support](https://d2908q01vomqb2.cloudfront.net/887309d048beef83ad3eabf2a79a64a389ab1c9f/2021/04/20/Screen-Shot-2021-04-20-at-13.36.10.png)
You use the SAVEPOINT command to create a savepoint. You can divide a transaction into smaller parts using what are called savepoints.
![oracle 10g end of support oracle 10g end of support](https://www.performing-databases.com/wp-content/uploads/2015/10/Oracle-Lifetime-Support-Oct-2015.png)
the session terminates abnormally If your session terminates abnormally, Oracle uses the relevant undo segment to roll the database back to its state before the current transaction began. you disconnect from the database If you disconnect from the database, the current transaction is committed automatically. It then runs and commits the DDL statement. You execute a data definition language (DDL) command When you execute a data definition language (DDL) command - such as CREATE, ALTER, or DROP - Oracle commits all data manipulation language (DML) statements - such as ADD and DELETE - in the transaction.