Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

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

1,333 views
Skip to first unread message

Frank Langelage

unread,
Jun 27, 2013, 4:21:18 PM6/27/13
to
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

Matthias Hoys

unread,
Jun 27, 2013, 4:52:15 PM6/27/13
to
Downgrading from EE to SE, is this actually supported?

Matthias

Justin Mungal

unread,
Jun 28, 2013, 12:10:59 AM6/28/13
to
Export / Import into a new SE database is the only supported method that I know of...
0 new messages