RE: How to import LOBSEGMENT using data pump impdp?

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Shastry(DBA) Sent: Tuesday, June 15, 2010 10:22 AM
To: oracle-l; ora-apps-dba_at_freelists.org Subject: Re: How to import LOBSEGMENT using data pump impdp?  

Any pointers please?  

-Thanks,

An

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