Fwd: Snapshot too old from READ-ONLY table (data pump export)
From: Jan-Hendrik Boll <jan.hendrik.boll_at_googlemail.com>
Date: Tue, 19 Jul 2011 09:47:43 +0200
Message-ID: <CAMqF_e2BpTrMA2JypeGZsBZ4tJoic5fMWKX5gs8YR5ZvOHM_rg_at_mail.gmail.com>
Hi,
Date: Tue, 19 Jul 2011 09:47:43 +0200
Message-ID: <CAMqF_e2BpTrMA2JypeGZsBZ4tJoic5fMWKX5gs8YR5ZvOHM_rg_at_mail.gmail.com>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Jul 19 2011 - 02:47:43 CDT