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.
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 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
Received on Thu Jun 27 2013 - 22:21:18 CEST