Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!newshub.sdsu.edu!headwall.stanford.edu!newsfeed.news2me.com!newsfeed2.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!sn-xit-03!sn-xit-11!sn-xit-05!sn-post-01!supernews.com!corp.supernews.com!not-for-mail
From: DA Morgan <damorgan@psoug.org>
Newsgroups: comp.databases.oracle.misc
Subject: Re: how to find out what COMPRESSION in a table(oracle 8.1.7.4)
Date: Mon, 08 Aug 2005 11:17:15 -0700
Organization: Ye 'Ol Disorganized NNTPCache groupie
Message-ID: <1123514226.374757@yasure>
User-Agent: Mozilla Thunderbird 1.0.2 (Windows/20050317)
X-Accept-Language: en-us, en
MIME-Version: 1.0
References: <1123032631.627257.91570@z14g2000cwz.googlegroups.com> <1123039893.841918@yasure> <42f09fd5$0$6989$9b4e6d93@newsread2.arcor-online.net>
In-Reply-To: <42f09fd5$0$6989$9b4e6d93@newsread2.arcor-online.net>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Cache-Post-Path: yasure!unknown@67.136.137.87
X-Cache: nntpcache 2.4.0b5 (see http://www.nntpcache.org/)
X-Complaints-To: abuse@supernews.com
Lines: 57
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.misc:121111

Maxim Demenko wrote:
> DA Morgan schrieb:
> 
>> dominica@gmail.com wrote:
>>
>>> Hi All,
>>>
>>>   I have a problem with COMPRESSION.
>>> Basically, I have upgrade from 8.1.7.4(solaris ) to
>>> 10g (solaris 64bit).
>>>
>>> And then I have a problem when I try to select from one of my
>>> partition_table which has COMPRESSION.
>>> I got ORA-28665 , and  I know what the fix is.
>>>
>>>
>>> I did check the dba_tab_partitions table, there is a NEW FIELD
>>> called COMPRESSION , and it has N/A on it after upgrade.
>>>
>>> Same thing for dba_tables, the new field "compression" is also
>>> empty, I need to run this;
>>>
>>> ALTER TABLE <iot> MOVE COMPRESS [<compress value>];
>>>
>>> But I need to know my original "compression value" ,
>>> I know I could ask the developer for the "create table script".
>>>
>>> But there must be some where storing in the data-dictionary in
>>> my oracle 8 DB???
>>>
>>> Anyone has any idea.
>>>
>>> Dominica
>>
>>
>>
>> Tables are not compressible in 8i.
> 
> 
> I assume, OP refers to compressed IOT (available in 8.1.7.4) .
> In that case you find "compression value" as
> SELECT PREFIX_LENGTH FROM DBA_INDEXES WHERE TABLE_NAME = 'my_iot_table' 
> AND INDEX_TYPE = 'IOT - TOP';
> 
> 
> Best regards
> 
> Maxim

Perhaps. But that was an assumption I was unwilling to make.

No response from OP so he is on his own.
-- 
Daniel A. Morgan
http://www.psoug.org
damorgan@x.washington.edu
(replace x with u to respond)