Re: expdp and ORA-01555

From: Rich <richa03_at_gmail.com>
Date: Mon, 6 Apr 2009 10:19:54 -0700
Message-ID: <26279fb90904061019i2a1371bfx19d0b5059f4b05c2_at_mail.gmail.com>

I'm running another scan of the LOBs for corruption as suggested by Youg (slower version), just in case.

Right now, I'm leaning toward delayed block cleanout as the issue (thanks Dave).

However, following Oracle SR suggestion, I am also running a full trace on the export - see ML Note *286496.1*

After the export fails, I think analyze might be a better course of action so the indexes and other associated objects are hit also - an FTS won't touch the indexes and they might have been lazy written as well (pretty active DB).

Thanks for the help!

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

Received on Mon Apr 06 2009 - 12:19:54 CDT