RE: expdp and ORA-01555

  • From: Tanel Poder <tanel.poder.003@xxxxxxx>
  • To: "'Yong Huang'" <yong321@xxxxxxxxx>
  • Date: Thu, 28 Aug 2008 14:39:07 +0800

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

Tanel Poder - n.ote this!

> -----Original Message-----
> From: Yong Huang [mailto:yong321@xxxxxxxxx] 
> Sent: Thursday, August 28, 2008 02:27
> To: Tanel Poder; richa03@xxxxxxxxx
> 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


Other related posts: