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>
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?
-- http://mgogala.freehostia.comReceived on Sun Oct 12 2008 - 03:39:18 CDT