RE: expdp and ORA-01555

From: Tanel Poder <>
Date: Thu, 28 Aug 2008 14:39:07 +0800
Message-id: <25A2BF45A40E4C08B2EC2F1396FA5DAB@windows01>

Ah ok, I had missed the LOB corruption part in your post, thus neither retention nor pctversion settings help.

If corruption is involved, this might be happening:

  1. expdp scans through LOB blocks
  2. ...and hits a corruption error which means that the lob block reading function returns a failure code
  3. there's a bug in code which assumes that whenever this lob block reading function fails, it means the block was already overwritten (thus raises ORA-1555
Tanel Poder - n.ote this!

> -----Original Message-----
> From: Yong Huang []
> Sent: Thursday, August 28, 2008 02:27
> To: Tanel Poder;
> Cc: 'Oracle-L Freelists'
> Subject: RE: expdp and ORA-01555
> Thanks. I tried retention. Still the same error. I guess all
> these are for future space usage, not the already corrupted blocks.
> I'm guessing the cause of the error in is the same
> as in But Oracle partially fixed the problem so the
> PL/SQL block in Note:452341.1 doesn't detect it. I haven't
> tried to get an error stack. I won't be surprised if it looks
> like Richa's.
> Yong Huang
Received on Thu Aug 28 2008 - 01:39:07 CDT

Original text of this message