RE: How to import LOBSEGMENT using data pump impdp?

From: Powell, Mark <>
Date: Wed, 16 Jun 2010 17:07:46 +0000
Message-ID: <>

I would expect the size reduction is due to wasted space in the LOB segment as the result of the pctversion setting and deleted lobs. The 'basic file' feature is not know be space efficient, which is supposed to be one of the improvements in 11g with the new 'secure files' LOB mechanism.

From: [] On Behalf Of Shastry(DBA) Sent: Wednesday, June 16, 2010 1:28 AM
To: Stefan Knecht; oracle-l; Subject: Re: How to import LOBSEGMENT using data pump impdp?

The issue what we had was the normal impdp method was not importing data and objects, later found that LOB's can be imported using REMAP option in data pump or using transportable tablespace as an option. Since the schema had data in different tablespaces we chose to go with data pump. I could import all the objects using REMAP option in data pump. But wonder the segment size got reduced to 40GB from 280GB. How is that possible? :) Please share.


On Tue, Jun 15, 2010 at 10:04 PM, Stefan Knecht <<>> wrote: A LOB is a column in a table. Look in user_lobs to find the table where it's stored.


Stefan P Knecht
CEO & Founder<>

10046 Consulting GmbH
Schwarzackerstrasse 29
CH-8304 Wallisellen

Phone +41-(0)8400-10046
Cell +41 (0) 79 571 36 27<><>

On Mon, Jun 14, 2010 at 6:40 PM, Shastry(DBA) <<>> wrote: Hello all,

Can you please advice in importing Object type LOB's of size 110GB,114GB in a schema using impdp (Data Pump)?

SEGMENT_NAME                                                                      SEGMENT_TYPE       BYTES/1024/1024/1024
--------------------------------------------------------------------------------- ------------------ --------------------
SYS_LOB0000032819C00008$$                                                         LOBSEGMENT                   119.702759
SYS_LOB0000032799C00039$$                                                         LOBSEGMENT                   117.594147
SYS_LOB0000032819C00009$$                                                         LOBSEGMENT                   12.2744141
SYS_LOB0000032799C00040$$                                                         LOBSEGMENT                   8.15449524
SYS_LOB0000032819C00002$$                                                         LOBSEGMENT                   8.99491882
SYS_LOB0000085482C00006$$                                                         LOBSEGMENT                   7.42799377
SYS_LOB0000032799C00033$$                                                         LOBSEGMENT                   6.45419312


Received on Wed Jun 16 2010 - 12:07:46 CDT

Original text of this message