Re: Imports / Compression
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Tue, 20 Sep 2011 15:37:18 +0000 (UTC)
Message-ID: <pan.2011.09.20.15.37.18_at_gmail.com>
On Tue, 20 Sep 2011 08:23:54 -0700, ExecMan wrote:
Date: Tue, 20 Sep 2011 15:37:18 +0000 (UTC)
Message-ID: <pan.2011.09.20.15.37.18_at_gmail.com>
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.
-- http://mgogala.byethost5.comReceived on Tue Sep 20 2011 - 10:37:18 CDT