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

From: Frank Langelage <frank_at_lafr.de>
Date: Thu, 27 Jun 2013 22:21:18 +0200
Message-ID: <b33l5vFgg9iU1_at_mid.individual.net>

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 - Production on Do Jun 27 22:13:58 2013

Copyright (c) 1982, 2006, Oracle. All Rights Reserved.

Verbunden mit:
Oracle Database 12c Release - 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 Received on Thu Jun 27 2013 - 22:21:18 CEST

Original text of this message