Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> How to Rebuild tablespace with Big Segment????

How to Rebuild tablespace with Big Segment????

From: Á¤µ¿Á÷ <jungdj_at_heung-a.co.kr>
Date: Tue, 05 Sep 2000 06:26:35 GMT
Message-ID: <vm0t5.6530$jM4.33687@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.
Received on Tue Sep 05 2000 - 01:26:35 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US