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
Received on Wed Aug 03 2005 - 05:38:55 CDT
