RE: How to import LOBSEGMENT using data pump impdp?
- From: "Sweetser, Joe" <JSweetser@xxxxxxxx>
- To: "oracle-l" <oracle-l@xxxxxxxxxxxxx>, <ora-apps-dba@xxxxxxxxxxxxx>
- Date: Tue, 15 Jun 2010 10:33:20 -0600
Any attempts so far/errors, please? Version? Platform?
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Shastry(DBA)
Sent: Tuesday, June 15, 2010 10:22 AM
To: oracle-l; ora-apps-dba@xxxxxxxxxxxxx
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@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: