Re: Index organized tables

I suppose for IOT PCTUSED=0, so empty blocks can be reused. Just only when data block will be
absolutely empty.

Serge Kosourikhin
Oracle DBA
JSC Bratsk Aluminium Plant

• Original Message ----- From: Igor Neyman <ineyman_at_perceptron.com> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Friday, May 26, 2000 10:09 AM Subject: Re: Index organized tables

You are right, if the index values will be reused. But, in my particular case I am purging historical data (column of 'date' type is a prefix in PK), so the values will never be reused. And, unfortunately I'm stuck with Standard edition - no partitioning option.

Igor

• Original Message ----- From: Colin.Shaw_at_phs.com To: Multiple recipients of list ORACLE-L Sent: Thursday, May 25, 2000 5:55 PM Subject: RE: Index organized tables

  Igor:

  ...empty space in the indexes will not be reused...

  Not true - if you re-insert the same index values, they will go to the "old" index nodes. Remember it's a sorted index - data *must* go in the correct place.

  Colin.
    -----Original Message-----
    From: Igor Neyman [mailto:ineyman_at_perceptron.com]     Sent: Wednesday, May 24, 2000 8:19 AM     To: Multiple recipients of list ORACLE-L     Subject: Index organized tables

    My question is - how to reuse space in Index Organized Table (IOT) after deleting substantial amount of rows.

    When I deal with regular table, after deleting a lot of rows I rebuild the indexes in order not to leave gaps in the index blocks, because we know that this empty space in the indexes will not be reused (unlike, when it is reused in table blocks after PCTUSED threshold met in the block).

    So, what could be done with IOT in order to prevent constant growth, even after a lot of rows being deleted?

    Igor Neyman, OCP DBA
    Perceptron, Inc. Received on Wed May 24 2000 - 20:36:15 CDT