Re: How to Rebuild tablespace with Big Segment????

Thanks for your Answer...

Export/Import time for 5million table is an only example.... I know that exp/imp performance can be improved as tuning(buffer size, direct path....)
I'd like to say that Imp/Exp has a limitaion for rebuilding big tablespaces or DB.

Let me know some information(web site,product overview) about Platinum TSReorg.

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:968165774.20321.1.pluto.d4ee154e_at_news.demon.nl...
>
> "Á¤µ¿Á÷" <jungdj_at_heung-a.co.kr> wrote in message
> news:vm0t5.6530$jM4.33687_at_news2.bora.net...
> > Hi, Guys.
> > We have the ORACLE 7.3.4.5 (OPS) on HP-UX 10.20.
> > Usually, to rebuild tablespace, we used IMP/EXP.
> > But, now data volumn is very big.So it's almost impossible to rebuild
> > tablespace using exp/imp.
> >
> > A month ago, I recovered one table (about over 5million rows) using
 EXP/IMP.
> > it spent about 18 hours....for only one table!!!!! Import was very very
> > slow.
> >
> > We are lookng up the good alternatives to rebuild tablespace except
 EXP/IMP.
> >
> >
> >
> >
> >
> There are none, or you should buy Platinum TSReorg.
> I would try to tune exp/imp first.
> You are aware of the most common measures to do this?
> If you don't use direct path export, increase the buffer to say 8M.
> Skip creating the indexes initially when importing. Create the index using
> the unrecoverable option.
> Exp/imp shouldn't last for 18 hours for one 5 million row table, and it
> definitely doesn't. Please post the commands you are using.
>
> Hth,
>
> Sybrand Bakker, Oracle DBA
>
>
>
Received on Tue Sep 05 2000 - 19:51:00 CDT