Re: Imports / Compression

From: ExecMan <artmerar_at_yahoo.com>
Date: Tue, 20 Sep 2011 09:03:20 -0700 (PDT)
Message-ID: <d270e923-534a-4cfc-aee5-74af436397c3_at_n12g2000yqh.googlegroups.com>



On Sep 20, 10:37 am, Mladen Gogala <gogala.mla..._at_gmail.com> wrote:
> 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.com

Sorry, it is SE (or maybe SE1). But if we cannot use compression, is there a way to uncompress during the export? Or, will we need to create new tables, uncompressed, then export. A real pain! Received on Tue Sep 20 2011 - 11:03:20 CDT

Original text of this message