Re: Imports / Compression

From: Mladen Gogala <>
Date: Tue, 20 Sep 2011 15:37:18 +0000 (UTC)
Message-ID: <>

On Tue, 20 Sep 2011 08:23:54 -0700, ExecMan wrote:

> Hi,
> We are exporting from 10g and importing to 11g. We encountered this
> error:
> IMP-00003: ORACLE error 439 encountered ORA-00439: feature not enabled:
> Basic Compression
> So ok, maybe compression is no longer free? But, how can I uncompress
> the tables and export them? I mean, if say for example, my database has
> 5000 compressed tables and each contain 1 million or more
> rows........does Oracle provide a way to export & uncompress?

Is the Oracle 11g database in question enterprise edition or some other type of install? Compression is only available in the enterprise edition. You can do export/import over the DB link and in that case you don't need compression.

Received on Tue Sep 20 2011 - 10:37:18 CDT

Original text of this message