Re: Check for uncompressed rows in compressed table

From: Mark D Powell <>
Date: Thu, 10 Apr 2008 09:34:24 -0700 (PDT)
Message-ID: <>

On Apr 10, 11:45 am, gareth <> wrote:
> Folks,
> Is it possible to check for uncompressed rows in a compressed table?
> I have looked everywhere and I cannot find an answer to this.
> Thanks in advance

I am unaware of any rdbms dictionary or v$ view that will provide this information.

The last I knew is that if a row in a compressed table was updated the updated row was stored uncompressed but this was on 9.2.

HTH -- Mark D Powell -- Received on Thu Apr 10 2008 - 11:34:24 CDT

Original text of this message