RE: expdp and ORA-01555

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

--
Regards,
Tanel Poder
http://blog.tanelpoder.com
http://n.otepad.com - n.ote this!
 



> -----Original Message-----

> From: Yong Huang [mailto:yong321_at_yahoo.com] 

> Sent: Thursday, August 28, 2008 02:27

> To: Tanel Poder; richa03_at_gmail.com

> 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 10.2.0.3 is the same 

> as in 10.2.0.2. 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

> 


--
http://www.freelists.org/webpage/oracle-l