Re: how to find out what COMPRESSION in a table(oracle 8.1.7.4)

From: DA Morgan <damorgan_at_psoug.org>
Date: Mon, 08 Aug 2005 11:17:15 -0700
Message-ID: <1123514226.374757@yasure>

Maxim Demenko wrote:

> DA Morgan schrieb:
> 

>> dominica_at_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_at_x.washington.edu
(replace x with u to respond)

Received on Mon Aug 08 2005 - 13:17:15 CDT