Fwd: Snapshot too old from READ-ONLY table (data pump export)

From: Jan-Hendrik Boll <jan.hendrik.boll@xxxxxxxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
Date: Tue, 19 Jul 2011 09:47:43 +0200

Hi,

I have one question about what happens after the ORA-01555:
If i am getting it correctly: the information stored in the block-header
says: uncommited changes, oracle tries to read the information from undo
which leads us to ORA-01555.

And what happens next to our changed block?
Is oracle perfoming a rollback on the uncommited blocks? (Wouldn't that lead
to ORA-01555 too?)

Regards
Jan-Hendrik Boll

Follow-Ups:
- Re: Fwd: Snapshot too old from READ-ONLY table (data pump export)
  - From: Laimutis . Nedzinskas
- Re: Fwd: Snapshot too old from READ-ONLY table (data pump export)
  - From: Stephane Faroult

References:
- Snapshot too old from READ-ONLY table (data pump export)
  - From: Brad Peek
- RE: Snapshot too old from READ-ONLY table (data pump export)
  - From: Bobak, Mark
- Re: Snapshot too old from READ-ONLY table (data pump export)
  - From: Brad Peek
- Re: Snapshot too old from READ-ONLY table (data pump export)
  - From: Chris Dunscombe
- Re: Snapshot too old from READ-ONLY table (data pump export)
  - From: Tanel Poder

Fwd: Snapshot too old from READ-ONLY table (data pump export)

Other related posts: