Surprisingly to many people, the SELECT will have generated redo. Not only that, but it will also have “dirtied” these Read More
Undo is conceptually the opposite of redo. Undo information is generated by the database as you make modifications to data Read More
This question is often asked. The simple short answer is no, since redo logging is crucial for the database; it Read More
Here is some general information about tables, regardless of their type: •\ A table can have up to 1000 columns, Read More
We will define each type of table before getting into the details. There are nine major types of tables in Read More
Now let’s take a look at how redo and undo work together in various scenarios. We will discuss, for example, Read More