Re: Imports / Compression

From: Mladen Gogala <>
Date: Tue, 20 Sep 2011 16:11:53 +0000 (UTC)
Message-ID: <>

On Tue, 20 Sep 2011 09:03:20 -0700, ExecMan wrote:

> 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!

The problem is in creating tables with the compressed attribute. Try this in your destination database:

SQL> create table t1(c1 varchar2(20),c2 number(10,0)) compress;

Table created.

If that succeeds, and I don't think it will, the problem is soluble by using the DB link for export/import. If not, you will have to create all compressed tables without the "COMPRESS" option before the import and import with TABLE_EXISTS_ACTION=APPEND

Received on Tue Sep 20 2011 - 11:11:53 CDT

Original text of this message