But the original poster was referring to a truncate ... aka Enron using your metaphor :-)
Cheers Connor --- Ron Rogers <[EMAIL PROTECTED]> wrote: > Good point Robert, > The reason the index space still exists after a lot > of deletes is the > method the index is stored in the database. very > similar to the old > organization chart of a large corporation. If you > eliminate all of the > people between the CEO and the janitor you still > have the multiple > levels displayed on the chart. The may be vacant and > just pointers to > the next lower level but the still exist on the > chart. Indexes are > stored the same way. One block points to the next > and so forth from the > top to the bottom. Remove all of the data between > the two and the "path" > from the top to the bottom still exists thus the > index storage is still > used. If you export the data, truncate the table and > import the data the > "path becomes top-to-bottom one step and the old > index storage area is > freed up. The janitor then reports directly to the > CEO. > Ron > ROR mª¿ªm > > >>> [EMAIL PROTECTED] 04/09/02 06:33PM >>> > There is not a HWM indicator for an index as there > is for a table. > When a truncate occurs, the blocks are cleared in > the index and the > extents (beyond the initial extent) are deallocated > (assuming you do > not > issue the reuse storage clause). > > RF > > -----Original Message----- > Sent: Tuesday, April 09, 2002 5:52 PM > To: Multiple recipients of list ORACLE-L > > > Hello, > > Lisa, what I was wondering when I read Rick's e-mail > was... what about > the > HWM for the indexes when someone truncates a table. > The table's HWM > pointer > gets reset of course, but I can never recall seeing > anything about > what > happens to the index space. > > Thank you, > > Paul Sherman > DBA > voice - 781-501-4143 (office) > fax - 781-278-8341 (office) > email - [EMAIL PROTECTED] > > > -----Original Message----- > Sent: Tuesday, April 09, 2002 5:33 PM > To: Multiple recipients of list ORACLE-L > > > Hi Rick, > > Nope. Try it. You'll see that the extents clear up > just like the > extents > in the table do, if you don't specify the REUSE > STORAGE clause. > > Lisa Koivu > Oracle Database Tank > Fairfield Resorts, Inc. > 954-935-4117 > > > > -----Original Message----- > > From: [EMAIL PROTECTED] > [SMTP:[EMAIL PROTECTED]] > > > Sent: Tuesday, April 09, 2002 5:11 PM > > To: Multiple recipients of list ORACLE-L > > Subject: Does index need rebuilding when table is > truncated > > > > Hi All, > > > > I know if you delete lots of data using delete the > indexes may need > > rebuilding. Is this the case if the table is > truncated? > > > > Thanks > > Rick > > > > > > -- > > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > > -- > > Author: > > 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). > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Koivu, Lisa > 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). > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Sherman, Paul 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). > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Freeman, Robert > 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). > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Ron Rogers > 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). ===== Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) "Some days you're the pigeon, some days you're the statue" __________________________________________________ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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).