Re: How to import LOBSEGMENT using data pump impdp?
- From: "Shastry(DBA)" <shastry17@xxxxxxxxx>
- To: Stefan Knecht <knecht.stefan@xxxxxxxxx>, oracle-l <oracle-l@xxxxxxxxxxxxx>, ora-apps-dba@xxxxxxxxxxxxx
- Date: Wed, 16 Jun 2010 10:57:34 +0530
Hi
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.
Thanks,
An
On Tue, Jun 15, 2010 at 10:04 PM, Stefan Knecht <knecht.stefan@xxxxxxxxx>wrote:
> A LOB is a column in a table. Look in user_lobs to find the table where
> it's stored.
>
> Stefan
>
>
> =========================
>
> Stefan P Knecht
> CEO & Founder
> s@xxxxxxxx
>
> 10046 Consulting GmbH
> Schwarzackerstrasse 29
> CH-8304 Wallisellen
> Switzerland
>
> Phone +41-(0)8400-10046
> Cell +41 (0) 79 571 36 27
> info@xxxxxxxx
> http://www.10046.ch
>
> =========================
>
>
>
> On Mon, Jun 14, 2010 at 6:40 PM, Shastry(DBA) <shastry17@xxxxxxxxx> 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
>>
>>
>> Thanks,
>> Shastry
>>
>
>
Other related posts:
