How to import LOBSEGMENT using data pump impdp?
- From: "Shastry(DBA)" <shastry17@xxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 14 Jun 2010 22:10:45 +0530
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:
