Re: How to import LOBSEGMENT using data pump impdp?

From: Stefan Knecht <knecht.stefan_at_gmail.com>
Date: Tue, 15 Jun 2010 18:34:46 +0200
Message-ID: <AANLkTim4JQo5UAqijDk6KhbCDEVomISjMazObaFmLj44_at_mail.gmail.com>

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_at_10046.ch

10046 Consulting GmbH
Schwarzackerstrasse 29
CH-8304 Wallisellen
Switzerland

Phone +41-(0)8400-10046
Cell +41 (0) 79 571 36 27
info_at_10046.ch
http://www.10046.ch

---

On Mon, Jun 14, 2010 at 6:40 PM, Shastry(DBA) <shastry17_at_gmail.com> 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
>

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Jun 15 2010 - 11:34:46 CDT