Re: How to import LOBSEGMENT using data pump impdp?

  • From: "Shastry(DBA)" <shastry17@xxxxxxxxx>
  • To: oracle-l <oracle-l@xxxxxxxxxxxxx>, ora-apps-dba@xxxxxxxxxxxxx
  • Date: Tue, 15 Jun 2010 21:51:38 +0530

Any pointers please?

-Thanks,
An

On Mon, Jun 14, 2010 at 10:10 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: