Re: Imports / Compression

From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Tue, 20 Sep 2011 16:11:53 +0000 (UTC)
Message-ID: <pan.2011.09.20.16.11.53_at_gmail.com>

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

-- 
http://mgogala.byethost5.com

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