Dennis, This is ERP application, So I don't want to touch any structures!!But I want my space back from last 3 heavy purges and want to improve response time by repacking the data. By truncating my highwatermark will come down from 25Gb size to half!! and it had 3 indexes size 15G.
>Date: Wed, 24 Jul 2002 11:29:45 -0800 > >Peter > If you don't do anything to the indexes, like drop them, they will >be there when you load the data back. Of course, if your table is really >large, then the load time will be longer. > You may also want to investigate ALTER TABLE MOVE. Now that command >will require you to rebuild the indexes. > What are you trying to accomplish by moving, truncating, moving the >data back? > >Dennis Williams >DBA >Lifetouch, Inc. >[EMAIL PROTECTED] > > _________________________________________________________________ Send and receive Hotmail on your mobile device: http://mobile.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter R INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
