expdp dump file and CLOB column

From: Mladen Gogala <mgogala_at_yahoo.com>
Date: Sun, 12 Oct 2008 08:39:18 +0000 (UTC)
Message-ID: <gcsd3l$bdu$1@registered.motzarella.org>

I have to import a 9GB dump file produced by expdp. My problem is space allocation. One of the columns is of the CLOB type and, for some reason, it produced a 45GB LOB segment. The obvious question is how do 45GB fit into 9GB export file? Is there an underlying compression? Are LOB objects in data pump dump files compressed? The logic tells me that they must be but I was unable to find any documentation. Does anybody have more info?

Received on Sun Oct 12 2008 - 03:39:18 CDT

Original text of this message