expdp dump file and CLOB column
Date: Sun, 12 Oct 2008 08:39:18 +0000 (UTC)
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?