Re: ORA-00439: feature not enabled: Basic Compression -- how to disable compression?

From: Matthias Hoys <matthias.hoys_at_gmail.com>
Date: Thu, 27 Jun 2013 13:52:15 -0700 (PDT)
Message-ID: <952580d2-edb3-49e6-b21c-a2bfab853817_at_googlegroups.com>

On Thursday, June 27, 2013 10:21:18 PM UTC+2, Frank Langelage wrote:
> I did an upgrade of my Oracle 11gR2.3 EE server to 12c SE.
>
>
>
> Now every create table gives 'ORA-00439: feature not enabled: Basic
>
> Compression'
>
>
>
>
>
> Seems I have activated 'Advanced Index Compression' while using 11 EE.
>
> 12 SE's Enterprise Manager show this enabled.
>
>
>
> How to disable this feature?
>
>
>
>
>
> sb2000.[maj2e_langfr]/mbi/mbi2e_all. db
>
>
>
> SQL*Plus: Release 10.2.0.3.0 - Production on Do Jun 27 22:13:58 2013
>
>
>
> Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
>
>
>
> Verbunden mit:
>
> Oracle Database 12c Release 12.1.0.1.0 - 64bit Production
>
>
>
> SQL> create table langfr_test ( x number );
>
> create table langfr_test ( x number )
>
> *
>
> FEHLER in Zeile 1:
>
> ORA-00439: Funktion nicht aktiviert: Basic Compression

Downgrading from EE to SE, is this actually supported?

Matthias Received on Thu Jun 27 2013 - 22:52:15 CEST