Before going through this article it will be helpful to read SQL – Transaction Statements -Transaction Management… and Savepoints In SQL Transactions. – SAVEPOINT to know more about SQL transactions.
Autonomous transactions are independent transactions that can be called from within another transaction.
A Transaction ensures that the action of a group of statements is atomic.A transaction is a logical unit of work that contains one or more SQL statements.The effects of all the SQL statements in a transaction can be either all committed or all rolled back.
Savepoints In SQL Transactions. – Oracle SAVEPOINT.
The intermediate markers within the context of a transaction called savepoints. Savepoints divide a long transaction into smaller parts.
The data in oracle is stored logically in tablespaces and physically in datafiles.
Tablespaces collectively store all of the database’s data.
FINDING oracle database objects, finding valid and INVALID objects and finding object counts – SQL Tips