Re: Block Corruption in empty pages in Oracle 11g
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Thu, 5 Aug 2010 11:54:11 +0000 (UTC)
Message-ID: <i3e8p3$vbn$1_at_news.eternal-september.org>
On Wed, 04 Aug 2010 20:08:15 -0700, zigzagdna wrote:
Date: Thu, 5 Aug 2010 11:54:11 +0000 (UTC)
Message-ID: <i3e8p3$vbn$1_at_news.eternal-september.org>
On Wed, 04 Aug 2010 20:08:15 -0700, zigzagdna wrote:
> Another strange thing I noticed:
> 1. When doing export backup, export backup reports about corrupted
> blocks.
Export is not a backup.
> 2. When I do expdp no errors are reported. So question is why is exp
> command checking empty blocks?
Because it's doing full table scans. Full table scan stops at HWM, not before. Also, exp utility is deprecated in 11.2. Do not use it.
-- http://mgogala.byethost5.comReceived on Thu Aug 05 2010 - 06:54:11 CDT