Re: Check for uncompressed rows in compressed table
Date: Thu, 10 Apr 2008 09:34:24 -0700 (PDT)
On Apr 10, 11:45 am, gareth <gareth.e..._at_britannia.co.uk> wrote:
> 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