Re: compress

Maxim Demenko wrote:
> Hi, list,
> did somebody experienced that behaviour?
> (there are no concurrent sessions)
> mmm_at_APPL> select count(*) from t_noc;
>
> COUNT(*)
> ----------
> 4506664
>
> mmm_at_APPL> alter table t_noc move compress;
>
> Tabelle wurde geändert.
>
> mmm_at_APPL> select count(*) from t_noc;
>
> COUNT(*)
> ----------
> 4506722
>
> I could reproduce this on 9.2.0.6 as well 9.2.0.4 on linux, i'd searched
> Metalink on this issue, but found nothing similar. I'll open an iTAR
> tomorrow, but, maybe, its a known bug, so any expirience will be
> appreciated. The only thing i can suspict at the moment - there are 2
> columns with varchar2(4000) and the blocksize is 8k, so maybe this is
> the row chaining that cause compress algorithm to fail...
>
> Best regards
>
> Maxim

Please post the result from the TAR.

Thanks.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)