RE: Index organized tables

From: Steve Adams <steve.adams_at_ixora.com.au>
Date: Thu, 25 May 2000 10:31:52 +1000
Message-Id: <10507.106607@fatcity.com>

Hello Igor,

The same principle applies. From 8i you can do it with ALTER TABLE MOVE.

Regards,
Steve Adams

http://www.ixora.com.au/
http://www.oreilly.com/catalog/orinternals/
http://www.christianity.net.au/


-----Original Message-----
From:	Igor Neyman [SMTP:ineyman_at_perceptron.com]
Sent:	Thursday, May 25, 2000 1: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.
(734)414-4627
ineyman_at_perceptron.com Received on Wed May 24 2000 - 19:31:52 CDT