Oracle updating records within same cursor
Here are few interview questions with answers found on the internet.
As I don't have time to format these questions to wiki I am just posting them hoping someone to format them. Explain the difference between a hot backup and a cold backup and the benefits associated with each.
Introduction: Prior to Oracle database 11g, adding a new column with a default NOT NULL value were a challenge.
Especially, when the concerned table contains thousands or millions of records.
Oracle has continued to improve and extend the possibilities for bulk PL/SQL processing through its 9i releases One and Two. It is assumed that readers are familiar with the bulk PL/SQL fetching and binding constructs available in Oracle 8i (i.e. If you require some background, follow the link to my 8i-specific article above.
We will be covering the following enhancements in this article.
In December 2001, I wrote a paper entitled Introduction to Bulk PL/SQL Processing in 8i.
This demonstrated the (then new) bulk PL/SQL processing enhancements introduced in Oracle 8i.
The process of adding the new column with a default NOT NULL value is now much more easy, and faster.
A hot backup is basically taking a backup of the database while it is still up and running and it must be in archive log mode.
A cold backup is taking a backup of the database while it is shut down and does not require being in archive log mode.
Therefore, commiting every so often would fix cause 1, but can do nothing about cause 2.
Are there any other scenarios where ORA-01555 can occurr?