Re: why aren't ORA-1555 errors MORE frequent?

On Wed, 20 Nov 2002, Howard J. Rogers wrote:

> You can certainly get 1555s when no-one is doing anything other than pure
> selects, true enough. They are incredibly hard to demonstrate, however,
> being as rare as hen's teeth.

This shouldn't be that difficult to demonstrate.

1. Restart your instance with less than 100 block buffers.
2. Update a big table (much, much bigger than 100 blocks), adding 1 to sum num column, and commit it.
3. Throw the tablespace in backup mode.
4. select * from the table.

Shouldn't this do it?

  |   The Moving Finger writes; and, having writ,                             |
  |   Moves on: nor all your Piety nor Wit                                    |
  |     Shall lure it back to cancel half a Line,                             |
  |   Nor all your Tears wash out a Word of it.                               |
  |                                                                           |
  |      -Rubaiyat of Omar Khayyam                                            |
  -----------------------------------------------------------------------------
 /   Charles J. Fisher   |   cfisher@rhadmin.org  |   http://rhadmin.org     /
-----------------------------------------------------------------------------